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
regional format.
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
format string.
1
Symbol
Description
(space)
Display spaces as literal characters.
2
“ABC”
Display anything inside quotation marks as
literal characters.
!
Force left alignment instead of right
alignment.
*
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
following: $#,##0.00[Green];($#,##0.00)[Red];”Zero”;”Null”.
\
Display the next character as a literal
character. You can also display literal characters by
placing quotation marks around them.
[color]
Display the formatted data in the color
specified between the brackets. Available colors:
Black, Blue, Green, Cyan, Red, Magenta,
Yellow, White.
Search JabSto ::




Custom Search