Microsoft Office Tutorials and References
In Depth Information
Changing the Format of a Field in Datasheet View
Changing the Format of a Field in
The Formatting group on the Fields tab in Datasheet view allows you to modify some
formatting for certain ﬁ eld types. When you format a ﬁ eld, you change the way data is
displayed, but not the actual values stored in the table. Next, you’ll open the Contract
table in the Belmont database to view the formatting of the ﬁ elds in the table.
To view the formatting of the Contract table’s fields:
1. Start Access, open the Belmont database you created in Tutorial 1, and make
sure the Navigation Pane is open. This database file should be located in the
Access1\Tutorial folder provided with your Data Files.
Trouble? If the Security Warning is displayed below the Ribbon, click the Enable
2. In the Navigation Pane, double-click the Contract table to open it in
3. On the Navigation Pane, click the Shutter Bar Open/Close Button
the pane and view more of the table datasheet. See Figure 2-5.
Contract table datasheet
Text fiel d values
field values are
Notice that the values in the three Text fields—ContractNum, CustomerID, and
ContractType—appear left-aligned within their boxes, and the values in the
ContractAmt and SigningDate fields appear right-aligned. In Access, values for
Text fields are left-aligned, and values for Number, Date/Time, and Currency
fields are right-aligned.
The ContractAmt ﬁ eld contains dollar values representing the total amount of each
Belmont Landscapes contract. Oren knows that these dollar amounts will never contain
cents because the contracts are drawn up in whole amounts only; therefore, the two
decimal places currently shown for the values are unnecessary. Further, Oren feels that
the dollar signs clutter the datasheet and are also unnecessary. He asks you to modify the
format of the ContractAmt ﬁ eld to remove the dollar signs and decimal places. You can
make these changes in Datasheet view using options on the Fields tab. You’ll also check
the format of the SigningDate ﬁ eld and modify it, if necessary.
To modify the format of the ContractAmt and SigningDate fields:
1. Click the Fields tab on the Ribbon.