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.
|@||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:|
Shows with the hyphens but is not stored with them.
Text shown just as typed
Forces all characters to upper case
Forces all characters to lower case
|Any text||Shows the word Unknown if there are no characters entered. Otherwise the text is shown just as it was entered.|
Last updated: September 17, 2012