Deselect after using Zoom

A

Arturo

I am using DoCmd.RunCommand acCmdZoomBox to open a field for viewing. After
opening, the entire field is selected/highlighted. How do I get Access to
deselect the entire field and go to the beginning of the field without
highlighting anything?

Thank you.
 
A

Arvin Meyer [MVP]

Arturo said:
I am using DoCmd.RunCommand acCmdZoomBox to open a field for viewing. After
opening, the entire field is selected/highlighted. How do I get Access to
deselect the entire field and go to the beginning of the field without
highlighting anything?
Click to expand...

It's done the same way that you control the cursor in the field:

Tools >>> Options >>> Keyboard tab

click on Go to start of field in the option group Behavior entering field.
 
A

Arturo

Can you do it with VBA instead? I don't want the user to have to do anything.
There could be several hundred users.
 
A

Arturo

Thanks again. that worked very well. Also, it won't be concurrent users.
There will be 5 to 10 at serveral locations.
 
Top