writing a macro

[fullymooned]

I need to set conditions to a field in a form. When I change the value of the field, if the value entered is greater than 0.8 and less than 1.71, it should pop up a message box saying "bad value" and set the value to 0.0

thank you

 

[anvil19]

Hi fullymooned

No macro is required here. Simply open the table in design mode, press F6 and select the Validation Rule line. Add the line <= 0.8 And >= 1.71 in the valadation rule line and a message like "Bad Value!" in the validation text line.

You should also set the default value to 0.0.

Try that.

anvil19