When we had our backend database in access, the users could scroll through a datasheet form and as they scrolled they would see the records whizzing by. Now with SQL server as the backend database, the scrolling has 2 problems. First, it only appears to load a certain amount of data in at a time, so when the user tries to scroll to the bottom of the list they really aren't at the bottom. Second, as they scroll, it does not show the data going by anymore.
Is there a way to correct this? One thing I have done is to force a goto last record then goto first record when they open the form. That cures the problem of not going to the end of the records when scrolling to the bottom (although the screen flashes when I do this). But I still can't see the records as I scroll.
If I can't correct the scroll view, is there a way to change the tooltip that shows up on the scroll bar? Right now it shows record number, but it would be satisfactory to show a field within the record.
Is there a way to correct this? One thing I have done is to force a goto last record then goto first record when they open the form. That cures the problem of not going to the end of the records when scrolling to the bottom (although the screen flashes when I do this). But I still can't see the records as I scroll.
If I can't correct the scroll view, is there a way to change the tooltip that shows up on the scroll bar? Right now it shows record number, but it would be satisfactory to show a field within the record.