Required Text in Hidden Controls

[Chip Gandy]

I have a form that has 4 sections, all hidden and depending on selections
made in the form, one of them will end up non hidden for the user to input
data. I need to make the fields required so that things will be input but
I'm having issues due to hidden controls. When the user hits submit, it
thinks that the fields in the hiddne controls should be filled out.

I can't use hte cannot be blank selection and have tried using data
validation but it doesn't help any.

Any ideas would be apprecaited.

Thanks

 

[Renee in Juneau]

You probably need to rethink your design.

How can you require fields to be filled out and yet not provide access
to them? Obviously not all the fields are required all the time.

Perhaps you can set data validation on those specific fields based on
whatever criteria you're using to determine which sections become
unhidden plus the fact that they can't be blank under some condition.