PC Review Forums Newsgroups Microsoft Outlook Microsoft Outlook Form Programming Re: How to have a field value require additional fields

Reply

Re: How to have a field value require additional fields

 
Thread Tools Rate Thread
Old 29-04-2004, 10:56 PM   #1
Sue Mosher [MVP-Outlook]
Guest
 
Posts: n/a
Default Re: How to have a field value require additional fields


You can use a validation formula for this, e.g.:

([Field1] = "") OR ([Field2] <> "")

This makes Field2 required if Field1 is non-blank, both being text fields.
Use it as the validation formula for Field2.

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


"Jon D" <anonymous@discussions.microsoft.com> wrote in message
news:08268EDF-9CEB-48D1-9053-275AE1CD2971@microsoft.com...
> I am trying on a outlook form to have a field that if a value is entered

then it makes multiple fields required but only if the initial field is
completed.


  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off