Click on Control Needs to work like TAB

[Nancy2]

Selecting Contents of Text/Combo box on Click
--------------------------------------------------------------------------------
Hello -

I need to ensure text gets selected when a user clicks in the text or combo box.

Using the Got Focus event I've tried:

HeadFootTrim.SelStart = 0
HeadFootTrim.SelLength = Len(HeadFootTrim.Text)

But, the click event seems to occur after got focus AND my code does not run on the Click event at all.

Help -- getting desperate!

Thank you

 

[LonnieJohnson]

Place your code in the controls On Click event. I tried this and it worked for me.

Private Sub MyField_Click()
MyField.SelStart = 0
MyField.SelLength = Len(MyField)
End Sub
ljprodev@yahoo.com
ProDev, MS Access Applications B-)

http://www.galaxymall.com/software/PRODEV

 

[Nancy2]

Thank you -- tried it again on click of the combo box and it did not work -- but since it works for you I tried it on a regular text box AND -- it did!

So, any idea why the click event behaves differently on a combo box than a text box? Any ideas how to address this?

Nancy

 

[Nancy2]

Did some more playing -- I cannot get the click event to occur with a combo box - I did however put code under the got focus event of the box

cboHeadFootTrim.dropdown

This might have to do - it does select it. But, I would prefer not to have to drop it down 1) confusing to user and 2) coding ease - different code for combo vs text box