|
Format Field |
|
|
Format Field |
|
Used to specify the format for xfd:field.
To enter into the Format Field dialog, right click on the field in Design View and then select Format...
Format Field dialog contains format options for Number, Currency and Data/Time. If you select None, then no format will be applied to your field.
None - No format. This will clear the format of the current field.
Number - specifies the format of numbers. You can choose from Predefined format or Custom format.
For the Predefined format you have the following options:
Format |
Example |
#,###.# |
1,234.5 - US Number Format |
#.###,# |
1.234,5 - Europe Number Format |
If you want to customize your format, select Custom and then make the setttings on:
| • | Decimal places - specifies the number of decimales. |
| • | Leading zeros - specifies the number of leading zeros. |
| • | Decimal separator - specifies the character used to separate the decimals from the rest of the number. |
| • | Thousand operator - specifies the character used to separate the thousands. |
Currency
Specifies the format for currency. You can choose from Predefined format or Custom format.
For the Predefined format you have the following options:
Format |
Example |
$#,###.# |
$1,234.5 - US Number Format 1 |
#.###,#€ |
1.234,5€ - Europe Number Format 1 |
£#,###.# |
£1,234.5 - UK Currency Format 1 |
#,###.#$ |
1,234.5$ - US Currency Format 2 |
€#.###,# |
€1.234,5 - Europe Number Format 2 |
#,###.#£ |
1,234.5£ - UK Currency Format 1 |
If you want to customize your format, select Custom and then make the setttings on:
| • | Decimal places - specifies the number of decimales. |
| • | Leading zeros - specifies the number of leading zeros. |
| • | Decimal separator - specifies the character used to separate the decimals from the rest of the number. |
| • | Thousand operator - specifies the character used to separate the thousands. |
| • | Currency symbol - specifies the symbol used for the currency. |
| • | Currency position - specifies the position in whitch the currency symbol will be placed. You can choose from "After" or "Before". |
Date/Time
Specifies the format for date and time. You can choose from Predefined format or Custom format.
For the Predefined format you have the following options:
Format |
Example |
yyyy-MM-dd |
2008-10-24 |
dd MMMM yyyy |
24 October 2008 |
dd MMM yyyy |
24 Oct 2008 |
EEEE MM yyyy |
Friday 10 2008 |
EEE MM yyyy |
Fri 10 2008 |
yyyy-MM |
Extract year and month: 2008-10 |
yyyy |
Extract year: 2008 |
MM-dd |
Extract month and day: 10-24 |
MM |
Extract month: 10 |
dd |
Extract day: 24 |
yyyy-MM-dd HH:mm:ss |
2008-10-24 15:51:36 |
yyyy-MM-dd hh:mm a |
2008-10-24 03:51 PM |
yyyy-MM-dd hh:mm:ss a |
2008-10-24 03:51:36 PM |
hh:mm:ss a |
03:51:36 PM |
HH:mm |
15:51 |
HH:mm:ss |
15:51:36 |
If you want to customize your format, select Custom and type the format you wish.
