3
Custom Text and Memo format settings can have two sections, separated by a semicolon.
The first section applies to fields containing text and the second to fields that are blank.
The following are some examples of using the Text and Memo format settings:
Format Setting
Entered As
Displays
@@@@-@@-@@@@
123456789
123-45-6789
@@@@@@-&&&&
92118
92118-
>
Jimmy
JIMMY
<
JIMMY
jimmy
@@\!
Hello
Hello!
@@;“No Data"
horse
horse
@@;“No Data"
(blank)
No Data
Number and Currency Fields You can format your Number and Currency data with one of
Access’s predefined formats or create your own using the special formatting symbols. The Format
property of a Currency field is automatically set to Currency but you can change it to any of the
other settings. The Format property of a Number or Currency field displays a list of the predefined
formats as described in Table 3-4.
CHAPTER 3: Create and Modify Tables
53
HowTo-Tght (8) / How to Do Everything with Microsoft Office Access 2003 / Andersen / 222938-1 / Chapter 3
Symbol Effect
!
Enters characters from left to right instead of right to left, forcing left alignment.
(Space) Enters a space as a literal character when the
SPACEBAR
is pressed.
“xyz" Displays the characters or symbols within the quotation marks.
*
Fills available space with the character that follows.
\
Indicates that the character that follows should be treated as a literal character. The back
slash is often used with reserved symbols and characters.
[color] Displays the field data in the color contained within the brackets. You can use black, blue,
green, cyan, red, magenta, yellow, or white.
TABLE 3-2
Custom Formatting Symbols
Symbol Effect
@
Indicates that a character or a space is required
&
Indicates that a character or a space is optional
<
Converts all characters to lowercase
>
Converts all characters to uppercase
TABLE 3-3
Text and Memo Format Symbols
P:\010Comp\HowTo8\938-1\ch03.vp
Thursday, August 07, 2003 6:37:20 PM
Color profile: Generic CMYK printer profile
Composite Default screen
|
|