Web forms support less format property settings for the different data types than client forms support. You also cannot specify any custom formats for the data types on web forms as you can for client forms; you must select a format option from the available list on the Property Sheet window. For text and Yes/No data types on web forms, there are no formatting options available. You can choose from six Format property settings for number and currency fields, as shown in Table 14-12.
Table 14-12. Format Property Settings for Number and Currency Data Types on Web Forms
Format | Description |
|---|---|
General Number | Displays numbers as entered with up to 11 significant digits. If a number contains more than 11 significant digits or the control you are using to display the value is not wide enough to show all digits, Access first rounds the displayed number and then uses scientific (exponential) notation for very large or very small numbers (more than 10 digits to the right or to the left of the decimal point). |
Displays numeric data according to the Currency setting in the Regional And Language Options section of the Control Panel. In the U.S. layout, Access uses a leading dollar sign, maintains two decimal places (rounded), and encloses negative numbers in parentheses. | |
Euro | Displays numeric data according to your Currency setting in the Control Panel, but always uses a leading euro symbol. |
Fixed | Displays numbers without thousands separators and with two decimal places. The number displayed is rounded if the underlying value contains more than two decimal places. |
Standard | Displays numbers with thousands separators and with two decimal places. The number displayed is rounded if the underlying value contains more than two decimal places. |
Percent | Multiplies the value by 100, displays two decimal places, and adds a trailing percent sign. The number displayed is rounded if the underlying value contains more than four decimal places. |
You can choose from five Format property settings for date/time fields, as shown in Table 14-13.
Table 14-13. Format Property Settings for the Date/Time Data Type on Web Forms
Format | Description |
|---|---|
General Date | Displays the date as numbers separated by the date separator character. Displays the time as hours, minutes, and seconds separated by the time separator character and followed by an AM/PM indicator. If the value has no time component, Access displays the date only. If the value has no date component, Access displays the time only. Example: 3/17/2011 06:17:55 PM. |
Long Date | Displays the date according to the Long Date setting in the Regional And Language Options section of the Control Panel. Example: Thursday, March 17, 2011. |
Short Date | Displays the date according to the Short Date setting in the Regional And Language Options section of the Control Panel. Example: 3/17/2011. To avoid confusion for dates in the twenty-first century, we strongly recommend you take advantage of the Use Four-Digit Year formatting options. Click the File tab on the Backstage view, click Options, click the Client Settings category, and then set these options in the General section. |
Long Time | Displays the time according to the Time setting in the Regional And Language Options section of the Control Panel. Example: 6:17:12 PM. |
Medium Time | Displays the time as hours and minutes separated by the time separator character and followed by an AM/PM indicator. Example: 06:17 PM. |