Datasheet View Very Slow When Tabbing Between Controls Across Screen Boundary

[ajs1952]

I am using Access 2010 and have experienced the above problem. I have googled this and found that it was a known problem in Access 2007 for which a hotfix was issued as here

http://support.microsoft.com/kb/972558.

Has anyone experienced this problem recurring in A2010? If so what was the solution? The application was not written by me and the client is keen on datasheet views so switching to a continuous form is not an option at the moment.

 

[dhookom]

Can you explain what you mean by "Across Screen Boundary"?

Duane
Hook'D on Access
MS Access MVP

 

[ajs1952]

Thanks for your interest Duane.

I mean that the form is wider than the screen and the users have to tab or use the horizontal scroll bar to view some of the controls. The right hand column is also frozen.

Tony

 

[dhookom]

Does the datasheet contain lookup fields and/or calculated columns?

Duane
Hook'D on Access
MS Access MVP

 

[ajs1952]

Yes it does, there is a definite pause when you tab thru a combo box.

 

[dhookom]

Do you need the ability to select from the combo box?
Do you need to include all records in the datasheet or can you apply a filter?
Are the fields in the combo box "relation" indexed?

Duane
Hook'D on Access
MS Access MVP

 

[ajs1952]

They do need to select from the combo box.
The datasheet is displaying a maximum of c60 records.
The combo box fields are "relation" indexed.

 

[dhookom]

How many records are in the combo box(es)?

I'm not aware of any other information beyond the link you posted.

Duane
Hook'D on Access
MS Access MVP

 

[ajs1952]

There are only about a dozen records (at most) in the combo boxes). To be honest Duane I'm coming to the conclusion it may be some issue with network processes such as the virus checker/offline file caching/office installation. Thanks for your thoughts, always useful to hear someone else's views. I am working with our network guys today, I'll post something later this week if anything transpires.

Tony