the Manx Man's MS Access Pages

Formatting Dates on Reports (014)

Here is my favourite way of formatting a date on a report.

Create the text box and in its format property put:

          mmm d, yyyy      gives a date like this:  Jan 24, 2000
or
          mmmm d, yyyy      gives a date like this:  January 24, 2000

What about a common header like this:

          "For the period of January 1, 2000 to January 14, 2000"

Create a text box and for its control source, put something like this:

          ="For the period of " & [Forms]![frmReport]![txtStartDate] &
              " to " & [Forms]![frmReport]![txtEndDate]

Make sure the text boxes on the form are formatted to "mmmm d, yyyy" for this example.

For a version of this tip that applies to Forms, click here.