When I try to change the Display Control on a Yes/No Data Type it reverts back to Check Box. I really want it to be a Text Box. Is there a sitting somewhere else that I have to set?
Kevin Robertson
@Reply 3 years ago
Add a Text Box to your form and change the Control Source to your Yes/No field.
Roger JacobOP
@Reply 3 years ago
Not on a form. Building a new table in query that will hold the value
Kevin Robertson
@Reply 3 years ago
Use the IIF function.
NewField: IIF(YesNoField, True, False)
When you run the query you will get 0 and -1 in the new column.
Right click on the new column and go to Properties.
In the Format box type in True/False.
You should now have a column of True and False Values.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Access Beginner 3.
