Edit a textbox from far left - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Edit a textbox from far left

Jerry Fowler

4 years ago

Took me a while but when I couldn't find it online I just started "Trying for myself" lol.  I want to start editing a date field from the far left when I clicked on it. Instead of clicking then moving to the far left.

Me.controlname.SelStart = 0

Now what I could use help on would be couild I make that a defauly for every textbox on a form?

I tried Me.Ctrl.Name.SelStart = 0
           or
    Dim ctrl As Control
    Dim fieldname As String
    fieldname = ctrl.Name
    Me.fieldname.SelStart = 0

and got nowhere.

	Jerry Fowler OP @Reply 4 years ago
Sorry I meant to add that I put this under form event current and load but neither did anything

	Kevin Robertson @Reply 4 years ago
You would need a Click event for each Text Box on your for that you wanted to run the code. Also, if it is the current form you don't need the `Me.` Example: `FirstName.SelStart = 0`

	Scott Axton @Reply 4 years ago
This doesn't work if you click in a field, but there is a setting when tabbing (or using enter) to move through fields. File -> Options -> Client Settings

	Scott Axton @Reply 4 years ago

	Maggie M @Reply 4 years ago
Try the following in the code area for the form: (Note: If you put this code in a GlobalMod and change Private to Public, you can call it for every form.) Private Sub SelectText(ctrl As Control) With ctrl .SelStart = 0 .SelLength = Len(.Text) End With End Sub Now call this sub from each click event of your text boxes, sending it the name of the text box. Hope this helps.

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View