test for value

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.
 
A

Allen Browne

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.
 

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

Form_Dirty problem 2
Evaluation timing 3
Cannot leave and save current record when using SetFocus 2
When does record become dirty? 10
Form Dirty not firing 10
test for events as they occur on a different form 5
A Continuous form field question 7
Events do not fire when assigning a value to a control using vba 3

Top