Not a programming problem.

[John Sh]

The top o' the new year to all.
I have just had to reinstall office 2010 due to problems loading Word and Excel but Access was not affected.
since the reinstall I have a peculiar problem with queries. I loaded the 32bit version as I have had strange results with the 64 bit one in the past.
When viewing a query in design mode, if I select any field, all fields to the left are selected.
If I try to drag the selected fields to the right each unselected field is added to the selection as I pass over it..
When I change to SQL view, regardless of where I put the cursor, all text to the right of the cursor is selected.
The only way I can work on a query is to select all in SQL mode and then copy it to notepad, or similar, and paste the corrected text back in to SQL mode.
Any clues?

 

[ebs17]

SQL Editor Add-In Recommendation

 

[bastanu]

Could it be that you have some sticky keys turned on?

5 Ways to Turn Sticky Keys On or Off on Windows 11

Want to make use of sticky keys on Windows 11? Or do you want to turn them off for good? Here's how to do both.

www.makeuseof.com

Cheers,

 

[John Sh]

Thank you for the replies.
When all else fails, restart the computer.
A second restart has fixed the problem, so some quirk of Windows 10 or Office 2010

 

[June7]

This is has happened to me but been a long time. Yes, restart Access and/or reboot computer.

 

[The_Doc_Man]

This happened to me a few months ago. A restart eventually straightened it out, but for a while is was ugly. Next time I'll remember to do that reboot sooner.