Microsoft Office Tutorials and References
In Depth Information
Formatting Fields with Field Properties
Formatting Fields with Field Properties
Field properties generally are used for formatting fields. They can also be
used to validate data, which we cover in Chapter 5 of this minibook.
Field properties are defined for each field (not surprisingly!). You can see
the field properties for only one field at a time. To see the field properties
for a field, select the field in the top half of the Design View window by
clicking the field selector (the gray box to the left of the row) or by clicking
anywhere in the row. The field selector of the active field is highlighted. Select a
new field to see a whole different set of field properties. The field properties
you see depend on the data type of the field. You won’t see the Decimal
Places property for a Text field, for example.
Book II
Chapter 2
Click a field property to see a short description to its right that tells you
whether the property is a formatting property and/or a data-validation
property. (Some properties can be used in both ways.)
How do you use field properties to format a field? For Number fields, you
can define the number of decimal places you want to display. For Text fields,
you can tell Access to change the text to all capital letters or all lowercase.
You can even use the Format property to add extra characters for display
purposes to Short Text or Long Text fields. (For most applications, however,
the Input Mask Wizard is easier to use than the Format property; we discuss
input masks in Chapter 5 of this minibook.)
Formatting Number and Currency fields
You can use the Field Size and Format properties together to define how
fields display. The common formats for Number and Currency fields are built
right into Access; you can choose among those listed in Table 2-3.
Table 2-3
Number Formats
Number Format
How It Works
General Number
Displays numbers without commas and with as many
decimal places as the user enters
Displays numbers with the local currency symbol (deter-
mined by the Regional settings in the Windows Control
Panel), commas as thousands separators, and two decimal
Displays numbers with the euro symbol, commas as
thousands separators, and two decimal places
Search JabSto ::

Custom Search