Select text in field

L

Lou Civitella

How can I have the user click on a text box and have all the text in the
field highlighted?
Preferrably on the On Click event of the field.

I want to simulate using the SendKeys "{F2}" but without using the SendKeys
function.

Thanks,
Lou
 
W

Wayne Morgan

In the control's OnClick event

Me.ActiveControl.SelStart = 0
Me.ActiveControl.SelLength = Len(Me.ActiveControl.Text)
 
L

Lou Civitella

Thanks Wayne this works great.

Wayne Morgan said:
In the control's OnClick event

Me.ActiveControl.SelStart = 0
Me.ActiveControl.SelLength = Len(Me.ActiveControl.Text)
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA word change keys 0
Word OLE to check spelling in text box 1
OLE Word spelling 0
Link a text box based on drop down box with four options MS Word 365 0
AppleScript - How do I select a text ? 1
ASK Field Formatting 1
Excel does not accept text format! 0
How do I set focus (and select text) on a text box on a modeless userform? 0

Top