Cannot be blank in hidden sections

K

knelsen

I have a section that is hidden unless a certain checkbox is true. How can I
make the controls in this section required only when the section is visible?
 
S

ScottD[Interlink Group]

You can get around this problem by using data validation rather than 'Cannot
be blank'. Whatever you use to determine if the section is hidden is used in
the condition such as "If <section Not Hidden> AND
<myRequiredField> is blank" Then show thie error: "cannot be blank"
 

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

Similar Threads

Create form with checkbox les that expand and collapse sections of the form? 0
Add a sequence number(question number) to a paragraph which has a question and 4 options and answer 0
Proposal template with removable sections 0
Document Merge Formatting Issue 0
Formating bolded text exclusively. 0
Cover Page - Use "Next Page Break" rather then Page Break 0
VBA to see if a Section exists in Word Document, and if it does, delete it 2
Use "Next Page Break" instead of "Page Break" on the cover page. 0

Top