OnChange

[JIM.H.]

Hello
OnChange event does not bring a text box value right.
Text0.Text is fine but not Text0.Value. In a AfterUpdate
event I am using Forms!FormName!Text0.Value=newvalue in my
module and returning newvalue to a disabled text box in
the form. OnChange event I use Len(Forms!FormName!
Text0.Text) but Forms!FormName!Text0.Value=newvalue does
not work.
Thanks,
Jim.

 

[Tom Wickerath]

Hi Jim,

The following is copied from the Dec. 2003 issue of Access-VB-SQL Advisor magazine (sideline on
page 25):

Prove It To Yourself
Here's a trick you can do with Northwind Traders. Open the Employees form to Nancy Davolio's
record. Nest, use Ctrl + G to open the debug window. Type this into the debug window:

?Forms!Employees!FirstName.Value

And:

?Forms!Employees!FirstName.Text

You should see "Nancy" returned in both cases.

Next, type "Betty" into the FirstName text box, but do not press Enter or Tab. Keep the focus in
the text box, and re-enter the "?Forms..." expressions into the debug window.

This time you should see "Nancy" as the Value and "Betty" as the Text (figure 3). Access doesn't
update the Value property until you press the Enter key or Tab off the control (go ahead, and try
it!).



Tom
__________________________________________


Hello
OnChange event does not bring a text box value right.
Text0.Text is fine but not Text0.Value. In a AfterUpdate
event I am using Forms!FormName!Text0.Value=newvalue in my
module and returning newvalue to a disabled text box in
the form. OnChange event I use Len(Forms!FormName!
Text0.Text) but Forms!FormName!Text0.Value=newvalue does
not work.
Thanks,
Jim.