Is this a bug to accept, or is there a fix?

[kirkm]

You click text in the query design grid criteria to edit it.

But editing is impossible as part of the text becomes immediately selected (highlit) and you can't get away from it. So you have to delete it and enter the whole thing. Or restart Access.

 

[isladogs]

I can't replicate your problem
Is this all queries or just one?
Have you tried with another database or on another PC?

 

[MarkK]

Hey kirkm, can you give more specific details about how you cause this problem?
Mark

 

[kirkm]

I've never sure exactly how or when it happens. You click in text expecting just the 'I' cursor, and instead a part of the text is highlit. You can't remove it.. if you try it may shift from one word to another. I then usually restart Access and it's OK again
Maybe it's to do with running (bad) code or queries while developing stuff. Can't say for sure about on another PC, but I've had it happen on many databases.
I only asked in case others have it happening too, and know why or how to fix it without restarting. And it's not only query design, but any text container.

 

[isladogs]

If its many databases, you may need to reinstall Access

But before you do so, check if you have all required VBA references in any affected databases

Also nne more thing that may or may not be relevant
If you have a form timer running in the background, it can cause unwanted side effects.

For example with one database I had a hidden form that was always running in the background to create a persistent connection to the SQL BE.
It also had a timer event
This caused the cursor to jump uncontrollably in the VB Editor - took me months to work out why & an unnecessary reinstall

HTH

 

[The_Doc_Man]

Last time I had this problem, I had to toggle the insert/navigate setting - the F2 key.

Don't know how it got set but that was it.