Microsoft Access Chinese help bugs

Format Property

The color name given in the original text is an error, the wrong color name is used, the desired result is not available, and the [color name] character appears.

Original:

You can use the Format property to customize how numbers, dates, times, and text are displayed. String type, readable/writable.

Expression. Format

expression required. Returns an expression for an object in the Applies To list.

Description

You can use a predefined format, or you can create a custom format using a format symbol.

format uses different settings for different data types. For information about a specific data type, see the following topics:

• Time/Date Data type
  
  
• Number and Currency data types
  
  
• Text and Memo data types
  
  
• Yes/No data type

For controls, you can set this property in the control's property sheet. For fields, you can set this property in table Design view (in the Field Properties section) or in Design view of the query window (in the property sheet > of the field Properties). You can also use macros or Visual Basic.

Note in Visual Basic, you can enter a substring expression that corresponds to a predefined format or enter a custom format.

The Format property affects only how the data is displayed, without affecting how the data is stored.

Microsoft Access provides predefined formats for time/date, number, and currency, text, and Memo and yes/no data types. Predefined formats are related to country/region settings by double-clicking the locale setting in Windows Control Panel. Microsoft Access Displays the format that corresponds to the selected country/region. For example, if you select English (United States) on the General tab, the currency format for 1234.56 is $1,234.56, and if you choose English (UK) on the General tab, the number appears as ￡1,234.56.

If you set the field's format property in table Design view, Microsoft Access uses that format to display data in a datasheet. The field's Format property is also applied to new controls on forms and reports.

The following symbols can be used in custom formats for any data type:

Symbolic meaning

Space	Displays a space as a literal character.
"ABC"	Displays the characters within the double quotation marks as literal characters.
!	Implement left alignment instead of right alignment.
*	Fills the available spaces with the next character.
\	Displays the next character as a literal character. You can also display it as a literal character by placing double quotes around it.
[Color]	Displays data formatted with the specified color between brackets. Available colors are: Black, blue, green, green, red, purple, yellow, white.

You cannot mix custom formatting symbols for data types such as the number and currency type with date/time, yes/no, or text and memo formatting symbols.

If an input mask is defined on the data and the format property is set, the format property takes precedence and ignores the input mask when data is displayed. For example, if you create a password input mask in table Design view, and you set the format property for a field, the data is displayed according to the Format property, regardless of whether it is in a table or a control on a form, and the password input mask is ignored.

That's right:

[Color]

Displays data formatted with the specified color between brackets. Available colors are: "Black, blue, green, blue-green, red, magenta, yellow, white"