Yes/No Data Type

  • Thread starter Thread starter Guest
  • Start date Start date
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"?
 
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.
 
Back
Top