Deselect after using Zoom

[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.

 

[Arvin Meyer [MVP]]

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?

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.

 

[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.

 

[Arvin Meyer [MVP]]

Try:

Application.SetOption "Behavior Entering Field", 1

Write a function adding the line above. BTW, I doubt that Access/JET can
handle several hundred concurrent users. I've successfully supported about
75 concurrent connections and would guess it might be able to do another 25,
but I can't guarantee that.
--
Arvin Meyer, MCP, MVP
http://www.datastrat.com
http://www.mvps.org/access
http://www.accessmvp.com

 

[Arturo]

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