Re: Making a textbox mandatory if a select items is chosen from a drop down list.

Hilary Stoupa — Mon, 27 Sep 2010 22:05:28 GMT

Hi & welcome:

You will need to apply two different techniques. First, conditional formatting on your text box control -- the condition would be that if the field for the drop down does not equal the value where the text box should be filled out, hide the text box. The second is data validation -- on the field for the text box, add data validation. The condition would be that if the field for the drop down is equal to the value where the text box should be filled out and the text box is blank, then the field is not valid.

Making a textbox mandatory if a select items is chosen from a drop down list.

jp_fondu — Mon, 27 Sep 2010 15:56:26 GMT

Hi there,

Probably a fairly simple one for most users here. Basically I have a drop down list with several items. However, one of the items requires a textbox underneath to be filled in if selected. I'd also like the box to then be mandatory.

Any ideas?

Cheers,

Newbie Questions

Re: Making a textbox mandatory if a select items is chosen from a drop down list.

Making a textbox mandatory if a select items is chosen from a drop down list.