-
yes/no box
I'm curious if a yes/no box can be put on a form like combo box. I know about the toggle buttons. I was hoping that it was possible to make it look like a combo box.
-
comboboxes only display text, so you can change the control to a combo with the following settings
rowsource: 0;No;-1;Yes
type: Value List
column count: 2
column width: 0
bound column: 1
-
When I go into the properties of the yes/no box, I don't see any of those
-
change the control to a combo
-
Looks like I'm going to pass on this. I don't even know how to change the yes/no to a combo. Couldn't find a way in the table. I tried the form, couldn't find how to do it in the properties.
-
in a table (not recommended because it hides the true values)
a) in design view, click on the Lookup tab for the yes/no field you want to change
b) in display control select Combo Box
c) populate properties as above
for a form
a) in design view delete your current checkbox control, if you have one
b) drag a combo control onto a form
c) populate properties as above, plus set the combo controlsource to the name of your yes/no field
-
That was amazing. Thanks. Now, is there a way to change yes/no to something else?
-
The combo box says yes/no, or true false. There is a drop down in the properties to put the words there. Is there a way to change the "yes/no" to different options?
-
the yes/no, true/false is a formatting property. you can change the rowsource
rowsource: 0;Elephants;-1;Lions
whatever you want
-
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules