Change Drop Down value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi,
Is there any way I can have a drop down that submits a value for only one of
the selections?

I would like to use a Drop Down for a Yes/No question.
If the user selects No then the word "No" is entered.
BUT if the user selects "Yes" then nothing is written to that field.

Is this possible with a drop down?
Thank you,
Jeff
 
Use a check box.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
Thanks, but a check box can be overlooked or ignored.
I could use validation with a drop down.
 
How about a text box, that requires YES to be typed in order to proceed?

You can use drop down, just set No to have no value, however you would need to have 3rd choice in
order to force the a selection in the drop down, like

Select = "" Set validation to disallow first choice.
Yes = Yes
No = " "

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
The drop down that you described is exactly what I would like. The problem
is, if I enter " " in the No field, then " " gets written into the database
field, quotation marks and all.
Is there any notation that will say don't write anything to the field? (a
Null character?)
 
Then why not just write No to the database, then you can always code any output to not display No.

--
==============================================
Thomas A. Rowe (Microsoft MVP - FrontPage)
WebMaster Resources(tm)

FrontPage Resources, WebCircle, MS KB Quick Links, etc.
==============================================
If you feel your current issue is a results of installing
a Service Pack or security update, please contact
Microsoft Product Support Services:
http://support.microsoft.com
If the problem can be shown to have been caused by a
security update, then there is usually no charge for the call.
==============================================
 
The way the system has been set up, I have to leave the field blank for one
response, and fill it in for the other. If the field is blank, the record
will be passed to the next level.

It sounds like there is no way to have one of the selections do nothing...
darn.
Thank you
 
Back
Top