Forum Discussion
VAL function in afterUpdate property of control
In a real estate properties DB I have a form with: 1. a ctrl, Tstnumb, for target street numbers. The underlying field is a text field 2. a ctrl for the value of ValTstnumb, which holds the value o...
you should probably use the Control's Name rather than the Fieldname:
Me!ControlName_Of_ValTstnumb_textbox = Val(Me!ControlName_Of_Tstnumb_textbox & "")
and use the Expression in the "BeforeUpdate" event of your Tstnumb_textbox control.
Me!ControlName_Of_ValTstnumb_textbox = Val(Me!ControlName_Of_Tstnumb_textbox & "")
and use the Expression in the "BeforeUpdate" event of your Tstnumb_textbox control.