Drop down Box

[Guest]

I would like to have a dropdown box in Access 2003 that I can slect YES or NO
to show up in the box. Is there a way to do it?
Thanks,
Frank

 

[Guest]

Use a combo box with a value list of "Yes;No"
Why not use an option group instead?

 

[Jeff Boyce]

Frank

"Dropdown box" (i.e., "combo box") is a type of control you'd put into a
form in Access. There's even a combo box wizard to help you build it (from
the Toolbar, inside the design mode for forms).

If none of this makes any sense, perhaps you could describe a bit more about
why you want to do this...

 

[Guest]

I do not know much about Access. I don't know what an option group is. I am
going to try and figure out the combo box thing.

Thank you for your help.

Frnak

 

[Guest]

Thank you. I am going to give the combo box a try.

 

[Guest]

I tried to make a combo box with the wizard and it did not work. What I am
trying to do is I have a field that I want yes of no to show up in.

In the data base I am trying to indicate if a file is active or not active
and want to indicate the answer with yes or no.

Does this help?

 

[Jeff Boyce]

Frank

As another responder pointed out, there are ways other than a dropdown box.

Before we get to the form, what data type is your underlying Active/Inactive
field in the table? If it is a Yes/No type field (my preference for yes/no,
active/inactive, etc.), you might want to consider using a simple checkbox
in your form.

The checkbox makes an easy, user-friendly way to indicate yes/no.