Solved Display Yes/No dropdown instead of a checkbox in a form (1 Viewer)

VzqCrs

Member
Local time
Today, 10:13
Joined
Nov 15, 2021
Messages
42
What is the best way to accomplish this?

In my table the field is set to Data Type:Format = Yes/No (Default Value is No)
Under Lookup I changed it to Text Box so that it displays Yes/No instead of a checkbox on the table.

When I add the field to my form I'd like it to display as a dropdown to select Yes or No but instead it's a textbox with the default value, which I guess is how it's supposed to work but what I really want is the yes/no dropdown. What do you recommend?
 

bastanu

AWF VIP
Local time
Today, 07:13
Joined
Apr 13, 2010
Messages
1,037
While in design view of the form right-click the textbox and choose Change To and select combo; then edit the combo by changing the Row Source Type to Value list,set the Column Count to 2,Column Widths to 0';1' and 0;No;-1;Yes for the Row Source values.
 

VzqCrs

Member
Local time
Today, 10:13
Joined
Nov 15, 2021
Messages
42
While in design view of the form right-click the textbox and choose Change To and select combo; then edit the combo by changing the Row Source Type to Value list,set the Column Count to 2,Column Widths to 0';1' and 0;No;-1;Yes for the Row Source values.
Thank you!
 

Users who are viewing this thread

Top Bottom