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...
 
You must log in or register to reply here.

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

Get Displayed Text of a ComboBox 2
The data in a linked Excel spreadsheet column is truncated to 255 characters in an Access database 0
Ho wto trigger an event after entering a number in a text box 11
neither beforeupdate nor afterupdate clear and keep focus on textb 7
Using '+' in DAP 1
Require Entry in Text Box 3
Alter Label in Report Section Header When Section Continues to Additional Page 1
Need help in formulating a function 1

Back
Top