How to Set Field Data Format in Access 2007
The field data formats in Access 2007 have been enhanced to improve the way that tables display information. They are dependent on the data types and a data format may be applied to an input mask. The following steps will show how to set the field data format to a table in Access 2007.
Other People Are Reading
Instructions
-
-
1
Open a database that already has a table created for it. Look at the Database window and click on the "Tables" line item in the "Objects" panel. Select the desired table listed in the right panel.
-
2
Ensure that you are looking at the table in Design View by selecting the "View" menu item on the "Table" window. Select the "Design View" if it has not already been activated.
-
-
3
Select the field for which you wish to change the format. Look at the lower part of the "Table" window at the "Field Properties" and click on the "General" tab if it is not already selected. Click on the "Format" property box, which should be the second property box in the list.
-
4
Click on the downward pointing arrow if one appears to bring up the drop-down list of available formats for that field's data type. Select the desired data format.
-
5
Provide custom formats for each data type in addition to the predefined formats. Note that the hyperlink, memo and text formats do not have predefined formats. As a simple example, you could enter & "box(es)" to append the string "box(es)" to any displayed quantity in a numeric field. This would show that this quantity always occurs in units of boxes.
-
1
