Down arrow key movement between records slower than up arrow on datasheet

RFigaro

Registered User.
Local time
Today, 07:41
Joined
Aug 5, 2012
Messages
18
I have a pop up form with a datasheet as a sub form. We use the up and down arrows to move between records. The problem is using the down arrow is 4 to 5 times slower than using the up arrow. This becomes a big problem when we hold down the arrow to move down 50 or more records. I believe it has something to do with the way the screen is repainted because in testing if I shrink the datasheet to show only 3 or 4 records the up and down movement is almost identical and matches the performance of the excel spreadsheet that this form was based on. Is there any fix for this?
 
Try going to the last record first and then back to the beginning and see if the results are different.
 
Thanks for the reply but unfortunately that didn't help. Anything else I could try?
 
What are the specs on the computer you are using? CPU, RAM, HDD, Speed of all
 
this issue is the same on every computer laptop/workstation/server new old etc... we tested on 7 different platforms all with access 2010 with the same results.
 
Your first instinct are probably correct. It is probably a presentation issue with ac2010. Sorry. There is a lot going on in a DataSheet View and each version of Access is slower.
 

Users who are viewing this thread

Back
Top Bottom