Multiple Records being select in datasheet view

[GregCotten]

I have an Access form that is displayed in datasheet view after the recordsource(table) is populated. In this datasheet view after everthing has loaded, I have the focus set to the first record (triangle appears beside the record). I also have the Double Click property to open another form once they double click in the grey section by any record. Here is the problem: For 2 users once they double click on a record it shows as if they have highlighted the lines.

Ex. Record 1 is selected by default, if the user double clicks on record 10, instead of the double click event triggering, the previous records will all be highlighted. It is like the user holds the shift key down. I know they are not because I have seen this after they have done it and it does not matter where they click because everything above will be highlighted.

Even more strange is this happens at random. It could be days apart when the issue occurs and the users are heavy users of the Access App.
Any thoughts anyone?

Greg

 

[HomeALone]

Sounds like your F8 key is pressed. Make sure your user didn’t accidentally press F8, also double check your double-clicks event didn’t call sendkeys F8. The next thing might be the MS Office problem that requires you have the most current service pack installed (recently SP3). Try all that and see if you can fit the problem. Good luck!

 

[GregCotten]

What does the F8 key do? I cannot find documentation on it.

Greg