Yes/No Data Type

G

Guest

I have a combo box on a form with a Yes/no format. The Row source is
"Yes";"No".
The Drop down is fine (Yes/No)
The table is Yes/no with a Yes/No format.

Yet when I select yes or No in the combo box, - 1 or 0 is displayed in the
text box, not "Yes" or "No"?
 
W

Wayne Morgan

Access stores Yes/True as -1 and No/False as 0. It will treat any non zero
number as if it was True. In form design view, go to the Properties for the
combo box, Format tab. In the Format box on that tab click the down arrow to
the right of the box. The arrow will appear after you click in the box. You
will be given 3 formatting options to choose from, Yes/No, True/False, and
On/Off. Pick the one you prefer.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Yes/No field custom format text color 1
MS Access problem 0
Combo Box won't select 4
realtionships - 3 different tables to be related on seperate table 2
Access how do you set a yes/no data type as required? 0
Access MS access forms list box problems 1
Checked box automatically checks for subsequent records 7
Yes/No options linking to other Fields 4

Top