Share via

Access Split Form's Navigation Buttons Not Displaying Number of Records

Anonymous
2021-09-10T22:30:02+00:00

Of my 7 Split forms only one will not display the number of records on the Navigation Buttons

at the bottom of form:

I have checked if there was a difference between this form and others and found non. I've

checked the same form in several backups and it is the same.

Not sure what I can do now. Only when I click on a record does it properly show the number of records.

James

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments No comments

8 answers

Sort by: Most helpful
  1. Anonymous
    2021-09-11T08:17:57+00:00

    It must've been a corrupted form. After checking several more backups I found one that displayed the number of records.

    Having many backups helped.

    If a form has become corrupted, in my experience a quick and simple way to fix it in most cases is to select the form in the navigation pane and copy it to the clipboard.  Then paste it back under a new name.  If the copy works correctly you can then delete the original and rename the copy back to the original name.

    Was this answer helpful?

    0 comments No comments
  2. George Hepworth 22,855 Reputation points Volunteer Moderator
    2021-09-11T01:50:48+00:00

    Either that or the initial state of the form was that it hadn't yet populated the full recordset and couldn't show the count because it wasn't yet available. Moving to the second record caused it to finish populating the record source.

    Was this answer helpful?

    0 comments No comments
  3. Anonymous
    2021-09-10T23:03:14+00:00

    It must've been a corrupted form. After checking several more backups I found one that displayed the number of records.

    Having many backups helped.

    Was this answer helpful?

    0 comments No comments
  4. Anonymous
    2021-09-10T22:54:49+00:00

    I'm expecting 214 records.

    When I select the second record it displays the record numbers like all my other forms.

    Was this answer helpful?

    0 comments No comments
  5. George Hepworth 22,855 Reputation points Volunteer Moderator
    2021-09-10T22:43:22+00:00

    How many records do you expect? Try navigating to the last record and then back to the first. It's likely the problem is related to whether the entire record set is/can be loaded immediately.

    Was this answer helpful?

    0 comments No comments