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 :