Base Auto-increment ID field out of sequence

Base, ID:0, Record 1: check, and so on until Record 5; ID 10! No harm done; records are still sequential and all present. The Total record becomes garbled, however: is, in fact, numerous integers typed on top of each other and unreadable. Should I worry about this; will it have consequences? What may have caused it? Thanks for your help!

You are talking about two different items.

First there is not necessarily any correlation between Record number and Auto-increment ID. Record number is simply how many records there are in the table, view, query etc. Record #1 in a display could become Record #311 if a different sort was applied. Auto-increment is the next sequentially available number as stored within the database. This can be changed through SQL. For example, the next number to be applied is 100. You can change this to re-start with 125 or 10000. Additionally, when a record is deleted, the number is not re-used.

Now it appears you are also talking about the navigation bar:

The lower bar is from the toolbars and has had problems in the 5.x versions. The topmost is actually the Navigation control. You can see there is no problem with the actual control and therefore the better choice.

Bingo! Lowermost is me. I will not worry. Thank you. How do I award Gold Stars to you?

Click on :heavy_check_mark: (upper left of answer) for correct answer (good to let others know correct answer given) and ^ is for a good answer. The down caret is for negative response or retraction of good answer.