In one of my databases, when I go to the last record, the Data sheet does not scroll all the way to the last record.
When I open the database and choose Records > Goto > Last Record, it scrolls near the end of the database, but not all the way down.
There are 1284 records in the database, and it seems to be going to about row 1260.
This happens consistently on opening the database. If I resize the data sheet window slightly, I can see the next record, and THEN, if I go to next record, it DOES go all the way to the end of the database.
Also, if I change the selected records - for example, by selecting those that match a certain value - and then Select All, at that point Records > Goto > Last Record works correctly.
I believe this is specific to one of my databases; after a little bit of testing on other databases, I don’t seem to be able to make it happen with them.
However, it’s very alarming to go into a database and have it appear that the last several weeks of data are missing.
Can you suggest anything I can check or try to try to fix this?
Thank you!