test for value

  • Thread starter Thread starter Bisha
  • Start date Start date
B

Bisha

I have a textbox with Control Source set to
=IIf([Form]![TxtKoefMin]>1000,1000,[Form]![TxtKoefMin])
I have to display a Msgbox when tha value of textbox is > then 1000. On the
Onchange Event of the Field I test for
filed.value > 1000 but it never fires up. Can somebody explain why it doest
fire up.I tried "Dirty event" with no success.

Thanks in advance for your help.
 
The Change event fires when the user types a keystoke that changes the Text
of the control. Since your control is bound to an expression, the user
cannot type anything there, so its Change event cannot occur.

If this is a bound form, the form's Current or AfterUpdate events may be
useful.
 
Back
Top