Make field required based on

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Pat Pollan - 03 Jan 2008 14:22 GMT

I would like to make a field 'required' based on the information entered into
another field on the form.....is that possible.

Reply to this Message

Paresh - 03 Jan 2008 14:31 GMT

On Jan 3, 7:22 pm, Pat Pollan <PatPol...@discussions.microsoft.com>
wrote:

> I would like to make a field 'required' based on the information entered into
> another field on the form.....is that possible.

Yes, you can use data validation to achieve this.

Thanks,
Paresh

Reply to this Message

zeon - 30 Jan 2008 19:02 GMT

I'm interested in doing something like this also, but data valadation does
not do what I want. I would like to say if field X is equal to some value,
then make field y a required field, an not allow submit until field Y is
filled in.

Data valadation only seems to allow you to create a pop-up or screen tip, or
am I missing something?

> On Jan 3, 7:22 pm, Pat Pollan <PatPol...@discussions.microsoft.com>
> wrote:
[quoted text clipped - 5 lines]
> Thanks,
> Paresh

Reply to this Message

Paresh - 31 Jan 2008 15:57 GMT

> I'm interested in doing something like this also, but data valadation does
> not do what I want. I would like to say if field X is equal to some value,
[quoted text clipped - 15 lines]
>
> - Show quoted text -

You can apply data validation on field Y with conditions as follows:
Field X ---is equal to --- <desired value> AND
Field Y ---is blank

<Message for screen tip>

Hope this helps.

thanks,
Paresh

Reply to this Message

zeon - 01 Feb 2008 16:59 GMT

Thanks, that worked.

> > I'm interested in doing something like this also, but data valadation does
> > not do what I want. I would like to say if field X is equal to some value,
[quoted text clipped - 26 lines]
> thanks,
> Paresh

Reply to this Message