Thread: Validation
View Single Post
  #3  
Old February 22nd 06, 07:32 PM posted to microsoft.public.outlook.program_forms
~KO
external usenet poster
 
Posts: 13
Default Validation

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!


Ads