Last Record not going to last record in one database

Panorama X
1

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!

2

I’ve never heard of such a thing, never seen such a thing myself (and I use Goto > Last Record frequently) and knowing how the code works, I think this is impossible.

This is probably a clue. Panorama does save the status of selected records. So when you open a database, not all records are necessarily selected. If you want to make sure they are, you should do a Select All first. It is not necessary to select a subset first.