Display formats

You can use the Format property to customize the way number and currency, dates and times, and text are displayed and printed. The Format property uses different settings for different data types.  An example of how a setting can change the way text is displayed is shown below. 

The information comes from Access / Help menu / search for Format / and Format Property in the topic box.

The text is in sentence case.  When the Format setting in the Properties window is changed the text all appears in CAPITAL letters.

format1.jpg (15024 bytes) format4.jpg (16485 bytes)
format3.jpg (37577 bytes)

Spaces between the text can be created with the @ symbol.

fo8.jpg (18291 bytes) fo10.jpg (18551 bytes)
fo9.jpg (36500 bytes)

Examine ways to customize number and currency, dates and times and text formats.

This work may be freely copied for non-commercial use only. Copyright © Pam Miller