Microsoft Office Tutorials and References
In Depth Information
Formatting a field
Formatting a field
In addition to having an Input Mask property that controls how
data is entered, a field also has a Format property that controls
how data is displayed. Access will pick up your international
settings for date/time and currency, and as long as you use one of
the built-in formats, the data will be displayed in an appropriate
In addition to supporting a list of built-in formats, you can also
use a combination of characters to specify a custom format for
the data. The Format property can also include patterns with
numerical data to display the data in specific colors, depending
on the data value.
Format a field
1 Select the field.
2 On the General tab of the Field Properties section, select from an
available format. (The formats shown here are for dates on a system
set with UK international settings.)
The following table provides information for entering a custom
Display spaces as literal characters.
Display anything inside quotation marks as
Force left alignment instead of right
Fill available space with the next character.
TIP We have listed here only a few of the basic formatting
characters, and we refer you to the online help for a list of
several tables of choices. In particular, there is an extensive range of
date/time formats, and for numerical values, the format can have up to
four parts (similar to an input mask), each of which can be associated
with a different color, depending on whether the value is less than
zero, zero, greater than zero, or null. For example, it could look like the
Display the next character as a literal
character. You can also display literal characters by
placing quotation marks around them.
Display the formatted data in the color
specified between the brackets. Available colors:
Black, Blue, Green, Cyan, Red, Magenta,