Microsoft KB Archive/98662

{|
 * width="100%"|

ACC1x: Formatting Yes/No Data Type Example

 * }

Q98662

-

The information in this article applies to:


 * Microsoft Access versions 1.0, 1.1

-

SYMPTOMS
If you type a format string in the Format property of a text box whose control source is a Yes/No data type, the format string will appear in the text box instead of the expected data when you view the form in Form view.

CAUSE
The format string for the text box is incorrect. This can occur if you follow the illustration on page 219 of Microsoft Access &quot;Language Reference.&quot; The illustration reads:

  &quot;;Always [Blue];Never [Red]&quot;

RESOLUTION
The illustration on page 219 should read:

  ;&quot;Always&quot; [Blue];&quot;Never&quot; [Red]