Microsoft Office Tutorials and References
In Depth Information
AC 168
Access Chapter 3 Maintaining a Database
To Specify a Format
To affect the way data appears in a fi eld, you can use a format . To use a format with a Text fi eld, you enter
a special symbol, called a format symbol , in the fi eld’s Format property box. The Format property uses different
settings for different data types. The following step specifi es a format for the Client Number fi eld in the Client
table and illustrates the way you enter a format. The format symbol used in the example is >, which causes Access to
display lowercase letters automatically as uppercase letters. The format symbol < causes Access to display uppercase
letters automatically as lowercase letters.
1
Select the Client Number fi eld.
Click the Format property box and
then type > (Figure 3–37).
What is the effect of this change?
From this point on, any lowercase
letters will appear automatically as
uppercase when users add records
or change the value in the Client
Number fi eld.
Client Number
fi eld selected
Client numbers are supposed to be
four characters long. Is there a way
to ensure users don’t type more
than four characters?
Yes. The Field Size property
dictates how many characters
the users can type, so if you
wanted to ensure that a maximum
of four characters be allowed, you
could change the fi eld size from
255 to 4.
Field Size
Format
Figure 3–37
 
Search JabSto ::




Custom Search