Reminder Time and Reminder Validation

  • Thread starter Thread starter srm
  • Start date Start date
S

srm

I'm using Outlook 2003. Before a I click on Save (custom task form), I
want to be prompted that if I have a Reminder time, I need to also
check the Reminder field. I have the following validation formula, but
I get prompted no matter if the reminder field is checked or not
checked or if the reminder is none and the reminder is not checked.

([Reminder Time] <> "None") And ([Reminder] = "Off")

I tried different variations but still cannot get it to work where I
have a reminder time, but not the reminder field checked and for it to
prompt upon Save.

Thanks

Shawn
 
What kind of prompt do you want? A validation formula doesn't give you a
"the data looks like this -- do you want to save anyway?" prompt. It simply
prevents Outlook from saving the item .

Note that a validation formula must return True if the data is "good" and
False if the data is "bad." Also, the Reminder field can have a Boolean
value of True or False, not "Off" or "True," which are strings.
 
What kind of prompt do you want? A validation formula doesn't give you a
"the data looks like this -- do you want to save anyway?" prompt. It simply
prevents Outlook from saving the item .

Note that a validation formula must return True if the data is "good" and
False if the data is "bad."  Also, the Reminder field can have a Boolean
value of True or False, not "Off" or "True," which are strings.
--
Sue Mosher, Outlook MVP
   Author of Microsoft Outlook 2007 Programming:
     Jumpstart for Power Users and Administrators
   http://www.outlookcode.com/article.aspx?id=54


I'm using Outlook 2003. Before a I click on Save (custom task form), I
want to be prompted that if I have a Reminder time, I need to also
check the Reminder field. I have the following validation formula, but
I get prompted no matter if the reminder field is checked or not
checked or if the reminder is none and the reminder is not checked.
Click to expand...
([Reminder Time] <> "None") And ([Reminder] = "Off")
Click to expand...
I tried different variations but still cannot get it to work where I
have a reminder time, but not the reminder field checked and for it to
prompt upon Save.

Shawn
Click to expand...
Click to expand...

Sue:

Thank you. With your guidance, I got it to work. Thanks again for all
your help.

Shawn
 
Back
Top