Formatting values on a report in Microsoft Access 2019

  1. Open the StudentRPT report in Design view, and then click on the unboundcontrol. Locate Property Sheet to theright of the database window and scroll down until you find the Format heading.
  2. Click on the drop-down list to locate Currency, then click on it with yourmouse. Press Enter on your keyboard to apply the format to theselected field. Change the DecimalPlaces value (found below the Format property to 0 decimalplaces). A quick way to scroll through the options in a drop-down listis to double-click repeatedly until you land on the desired fieldformat:
ms office 674
  1. Close the Property Sheet window, if necessary.

Leave a Comment