Table Field: Format Property

Controls how data is displayed in the datasheet. This formatting is inherited into queries, forms, and reports unless you apply new formatting in their Design Views.

Symbol	Description
@	Text character or a space is required
&	Text character is not required.
<	Force all characters to lowercase.
>	Force all characters to uppercase.

---

Format Property	takes data entered like:	and displays it as:
@@@-@@-@@@@	345678901	345-67-8901 Shows with the hyphens but is not stored with them.
@@@@@@@@@	345-67-8901 345678901	345-67-8901 345678901 Text shown just as typed
>	carpenter CARPENTER Carpenter	CARPENTER CARPENTER CARPENTER Forces all characters to upper case
<	carpenter CARPENTER Carpenter	carpenter carpenter carpenter Forces all characters to lower case
@;"Unknown"	Null value	Unknown
	Zero-length string	Unknown
	Any text	Shows the word Unknown if there are no characters entered. Otherwise the text is shown just as it was entered.