Select contents of a field on click?

[anoob]

Is it possible to set a property for a field on a form so that either the contents are selected, or the contents are cleared completely, when the field is clicked on (or "clicked into", or given focus...)?



My data entry is very slow when I have to hit delete several times before I am able to input an expense.

Many thanks!

[RuralGuy]

I believe that is the default action when you tab into a control but
Me.ControlName.SelLength = Len(Me.ControlName)
should also select everything in a TextBox. Using *your* Controlname of course - and the Enter Event is a good place to put this code.

[anoob]

Thank you for the reply - and this is probably an extremely ridiculous question - but when you say "Me", as in "Me.ControlName.SelLength" - does it actually mean something in Access or is that like a generic term for "Current Form" or something?

[pbaldy]

Allan is probably asleep by now. "Me" is used in Access to refer to the object containing the code. In your example here, it would refer to the form. It's a shorter method than the full form reference of:

Forms!FormName.ControlName

It's also useful because as soon as you type "Me." Intellisense will provide a list of most of the available objects and methods.

[anoob]

Ah! Very cool!

Thank you much guys!

[RuralGuy]

So are you ready to use the Thread Tools and mark this thread as Solved?

[anoob]

Thought I already did!
I saw the check that means "posted by OP" and thought it was already marked solved.

Oopsy.

[RuralGuy]

Thanks! Now we are up to date.