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)
http://www.ycoln-resources.com
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.
==============================================

"J-L-W" <(E-Mail Removed)> wrote in message
news:559EC4B9-D43C-452B-8314-(E-Mail Removed)...
> 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

Thanks, but a check box can be overlooked or ignored.
I could use validation with a drop down.



"Thomas A. Rowe" wrote:

> Use a check box.
>
> --
> ==============================================
> Thomas A. Rowe (Microsoft MVP - FrontPage)
> WebMaster Resources(tm)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "J-L-W" <(E-Mail Removed)> wrote in message
> news:559EC4B9-D43C-452B-8314-(E-Mail Removed)...
> > 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
>
>
>

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)
http://www.ycoln-resources.com
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.
==============================================

"J-L-W" <(E-Mail Removed)> wrote in message
news:76D2404B-01C2-4E53-8B5B-(E-Mail Removed)...
> Thanks, but a check box can be overlooked or ignored.
> I could use validation with a drop down.
>
>
>
> "Thomas A. Rowe" wrote:
>
>> Use a check box.
>>
>> --
>> ==============================================
>> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> WebMaster Resources(tm)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "J-L-W" <(E-Mail Removed)> wrote in message
>> news:559EC4B9-D43C-452B-8314-(E-Mail Removed)...
>> > 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
>>
>>
>>

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



"Thomas A. Rowe" wrote:

> 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)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "J-L-W" <(E-Mail Removed)> wrote in message
> news:76D2404B-01C2-4E53-8B5B-(E-Mail Removed)...
> > Thanks, but a check box can be overlooked or ignored.
> > I could use validation with a drop down.
> >
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> >> Use a check box.
> >>
> >> --
> >> ==============================================
> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> WebMaster Resources(tm)
> >> http://www.ycoln-resources.com
> >> 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.
> >> ==============================================
> >>
> >> "J-L-W" <(E-Mail Removed)> wrote in message
> >> news:559EC4B9-D43C-452B-8314-(E-Mail Removed)...
> >> > 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
> >>
> >>
> >>
>
>
>

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)
http://www.ycoln-resources.com
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.
==============================================

"J-L-W" <(E-Mail Removed)> wrote in message
news:3B444C3F-CFEE-4425-8D99-(E-Mail Removed)...
> 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?)
>
>
>
> "Thomas A. Rowe" wrote:
>
>> 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)
>> http://www.ycoln-resources.com
>> 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.
>> ==============================================
>>
>> "J-L-W" <(E-Mail Removed)> wrote in message
>> news:76D2404B-01C2-4E53-8B5B-(E-Mail Removed)...
>> > Thanks, but a check box can be overlooked or ignored.
>> > I could use validation with a drop down.
>> >
>> >
>> >
>> > "Thomas A. Rowe" wrote:
>> >
>> >> Use a check box.
>> >>
>> >> --
>> >> ==============================================
>> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
>> >> WebMaster Resources(tm)
>> >> http://www.ycoln-resources.com
>> >> 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.
>> >> ==============================================
>> >>
>> >> "J-L-W" <(E-Mail Removed)> wrote in message
>> >> news:559EC4B9-D43C-452B-8314-(E-Mail Removed)...
>> >> > 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
>> >>
>> >>
>> >>
>>
>>
>>

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

"Thomas A. Rowe" wrote:

> 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)
> http://www.ycoln-resources.com
> 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.
> ==============================================
>
> "J-L-W" <(E-Mail Removed)> wrote in message
> news:3B444C3F-CFEE-4425-8D99-(E-Mail Removed)...
> > 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?)
> >
> >
> >
> > "Thomas A. Rowe" wrote:
> >
> >> 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)
> >> http://www.ycoln-resources.com
> >> 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.
> >> ==============================================
> >>
> >> "J-L-W" <(E-Mail Removed)> wrote in message
> >> news:76D2404B-01C2-4E53-8B5B-(E-Mail Removed)...
> >> > Thanks, but a check box can be overlooked or ignored.
> >> > I could use validation with a drop down.
> >> >
> >> >
> >> >
> >> > "Thomas A. Rowe" wrote:
> >> >
> >> >> Use a check box.
> >> >>
> >> >> --
> >> >> ==============================================
> >> >> Thomas A. Rowe (Microsoft MVP - FrontPage)
> >> >> WebMaster Resources(tm)
> >> >> http://www.ycoln-resources.com
> >> >> 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.
> >> >> ==============================================
> >> >>
> >> >> "J-L-W" <(E-Mail Removed)> wrote in message
> >> >> news:559EC4B9-D43C-452B-8314-(E-Mail Removed)...
> >> >> > 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
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>