Make field required based on

P

Pat Pollan

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

Paresh

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
 
Z

zeon

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?
 
P

Paresh

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?







- 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
 
Z

zeon

Thanks, that worked.

Paresh said:
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
 
C

Cindy

hello, I have tried the data validation you suggested but it didn't work the
way I wanted it to. I have a field (x) that I want to make required unless a
checkbox field (y) checked. If y is checked x can be blank. My condition is
'x is blank and y is blank'. I would like to have the red asterisk displayed
on field x until field y is checked and have it disappear as soon as field y
is checked. Is that possible to do?I've tried this with the 'Cannot be
blank' check box checked and not checked. If checked y is required whether
or not field y is checked. If unchecked x is not required no matter what.
I've only tested this in the Preview Design.

Please advise, thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top