strMyString = the name of the text box

[Bill]

How do I create a string expression based on
whatever textbox currently has the focus?

I.e., strMyString = the name of the text box that currently has the focus

Bill

 

[Tom Wickerath]

Hi Bill,

Try something like this. I think it will work:

strMyString = Screen.ActiveControl.Name


Tom Wickerath
Microsoft Access MVP

http://www.access.qbuilt.com/html/expert_contributors.html
http://www.access.qbuilt.com/html/search.html
__________________________________________

 

[Duane Hookom]

You can try:
strMyString = [ActiveControl].[Value]

 

[John Nurick]

Hi Bill,

Screen.ActiveControl.Name
or
Screen.ActiveControl.Value
or
Screen.ActiveControl.Text
depending what you want to do.

 

[Bill]

Thanks Tom, Duane & John.
Bill

 

[Bill]

I used Tom's expression. And, since it worked perfectly
the first time and subsequently elsewhere, I didn't try the
other two offered by Duane and John.
Bill