updating Value attribute

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using the OnChange event to capture if the value of a text box has been
altered.
However, although text has been entered, when I check the value of the text
box using debug.print, I find that it remains whatever it was before the text
box got the focus. Is there any way of updating this value without moving the
focus?
 
If you specifically check for [YourTextBox].Text it will be what you have
just changed and not what it was before
 
Brilliant. Thanks Dennis.
Pete
Dennis said:
If you specifically check for [YourTextBox].Text it will be what you have
just changed and not what it was before

Italian Pete said:
I am using the OnChange event to capture if the value of a text box has been
altered.
However, although text has been entered, when I check the value of the text
box using debug.print, I find that it remains whatever it was before the text
box got the focus. Is there any way of updating this value without moving the
focus?
Click to expand...
Click to expand...
 
Back
Top