Formatting Results Displayed in a Calculated Field


You can specify the format for calculated field results by changing the format property.



To use the format property for calculated fields:

  1. With the query open in Design view, right-click in the calculated field.
  2. Click Properties... from the shortcut menu.
  3. Click in the Format box.
  4. Click the drop-down arrow.
  5. Click the format you want to use.
  6. Close the Field Properties dialog box by clicking the close box in the upper right corner.


Be careful that you are viewing the field properties and not the query properties. If the field does not have the Show check box checked, you will open the Query Properties dialog instead of the Field Properties dialog.

You can also open the field properties dialog box by:

  1. Clicking the Properties toolbar button.
  2. Selecting Properties... from the View menu.