So, what's the business logic at work here? Tell us in English; don't worry about the code. Under what conditions would a value there not be necessary?

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"~KO" wrote in message ...
There's always something else that crops up. The field works great if the
user was meant to put something in the amount, but there are times when they
do not have to fill it out. I tried to input 0.00 and it would not recognize
it as an amount. If I left the form set up this way, I would have to instruct
the user to input .01 if they did not have an amount to enter. Any ideas?
thanks!

"~KO" wrote:

You Rock Sue! Thank you so much for your quick and accurate response!

"Sue Mosher [MVP-Outlook]" wrote:

A validation formula must return True or False. I doubt that Amount is a Yes/Not field, so [Amount] would not be a valid validation formula. Maybe what you want to use is:

[Amount] 0

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"~KO" wrote in message ...
Outlook 2000

Properties / Validation on a field

I checked "Validate this field before closing form."

The Validation Formula is [Amount]

For "Display this message if validation fails:" - "Enter Amount."

The message does not display if field is empty and the form can be sent.

I do not have the "A value is required for this field" checked because if it
is checked, a message displays "A field on this form requires a value." It
does not tell me which field.

Thanks for your help and direction!