set focus selects all of the text

[markjkubicki]

when I add the code me.txtBoxName.setfocus, the focus does move the the designated textbox, however, in doing so, all of the text in the box is selected.
(I've not noticed this happening previously, or maybe, that's just it: I never noticed it... never-the-less...)



Is there a way to just have the curser move to in front of the first character?

many thanks in advance
mark

[nicknameoscar]

If I am reading your question correctly go click on the Microsoft Office symbol in the extreme upper left corner of the Access user interface. At the bottom of the resulting tab click on the "Access Options" command button. Then click on "Advanced" in the list on the left. In the "Behaviour entering field" option group click "Go to start of field".

[markjkubicki]

is this an option that I can chage with code?

(I suspect that others may be having this problem, and it would be good if I could change it in the project when it loads (and then, of course, change it back when closing it)

[nicknameoscar]

Check out the "SelStart" property. You may also be interested in "SelLength".

HorseName below is a textbox and strCharacterCount holds the number of characters typed so far. The code below positioned the cursor after the last character typed. You probably just want to use 0 (or is it 1):

frm!HorseName.SelStart = strCharacterCount