Microsoft Office Tutorials and References
In Depth Information
Elsa wants the dates to be displayed with a two-digit month (mm), a two-digit day (dd), and
a four-digit year (yyyy). You’ll enter this custom format now.
7. Click the Format list arrow to close the list of predefined formats, and then type
mm/dd/yyyy . See Figure 2-12.
Specifying the custom date format
Help information about
the Format property
8. Set the Caption property for the field to Start Date .
Next, you’ll define the ninth and final field, EndDate. This field will have the same definition
and properties as the StartDate field.
9. Place the insertion point in the ninth row’s Field Name text box, type EndDate , and then
press the Tab key to advance to the Data Type text box.
You can select a value from the Data Type list box as you did for the StartDate field.
Alternately, you can type the property value in the text box or type just the first character
of the property value.
10. Type d . The value in the ninth row’s Data Type text box changes to “date/Time,” with the
letters “ate/Time” highlighted. See Figure 2-13.