Help

Editing objects, layout parts, and the layout background
F
ILEMAKER PRO HELP 333
• Only numbers are displayed and printed in a number field formatted as decimal (except for
separators and notations specified in the Inspector). To display text and symbols (for
example, @1.98 per pound) in a number field, select As entered. If you use the field in a
calculation or summary, only the numeric value is used.
• If you specify the format as Boolean, any values in the number field that contain non-
numeric data display as blank because they do not contain any numeric content. For
example, the value “ABC” would display as blank. However, non-numeric field content
returns false in calculations.
• For more information about defining number fields, see About number fields.
Related topics
Defining conditional formatting for layout objects
Specifying formats for date fields
You can control how FileMaker Pro displays the values in date fields and calculation fields with date
results.
To specify formats for date fields:
1. In Layout mode, select one or more date fields or calculation fields with a date result.
For more information, see Selecting objects.
2. Click Inspector in the layout bar, then click Data.
3. In the Data Formatting area, click Date , then select the formats you want to use from
the Format list.
To display dates Do this
Exactly as entered For Format, select As entered.
In a predefined format For Format, select a format.
To change the separator between parts of a numeric date, for
Numeric separator, type another character.
In a custom format For Format, select Custom and choose options and separator
characters for day of week, month, day of month, and year.
With leading zeros (as in
01/02/99) or leading spaces in
numeric parts of dates
In the Leading character area, choose <None>, Zero, Space
for For day numbers, For month numbers, or both. (This option
is not available if you've chosen As entered.)
With different text formatting Select text options using the Appearance tab of the Inspector.
See
Specifying text formats for fields.
Using a different Japanese date
display (if you’re using a font that
contains Japanese characters)
In the Japanese area, for Numeral type, choose a display type.
Using the current system formats
for dates
For Format, select Short System Date (for example, 11/11/
2014) or Long System Date (for example, Tuesday, November
11, 2014).
FileMaker Pro formats dates based on the current system
formats when the file is opened.