ACC1x: Formatting Yes/No Data Type Example

ID: 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 "Language Reference." The illustration reads:


   ";Always [Blue];Never [Red]"

RESOLUTION

The illustration on page 219 should read:


   ;"Always" [Blue];"Never" [Red]

REFERENCES

Microsoft Access "Language Reference," version 1.0, page 219


Keywords          : kbusage FmsOthr 
Version           : 1.0
Platform          : WINDOWS 
Issue type        :

Last Reviewed: March 23, 1999