FORMS CHECKING

[WWV]

I have a field on a form that is defined as currency in the table. I want to
check the field for 0.00 and show a error msgbox if it is ( I want the user
to be required to enter a dollar cents amount). I don't want to change the
table, only check on the form. I see other messages about null, but not how
to check for zero. Thanks

 

[Jeff Boyce]

One approach might be to add a Validation Rule to the control on the form,
and a message.

Or you could use the control's BeforeUpdate event to add code to do the
validation.

Regards

Jeff Boyce
Microsoft Office/Access MVP