Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

month formatting

ResolvedVersion 2007

Kate has attended:
Access Introduction course

Month Formatting

Can you format a date field to month field?

Edited on Sat 26 Jul 2008, 07:21

RE: Month Formatting

Hi Kate, Thank you for your post, formatting a date field to only display Month is quite straightforward.

In design view in the Form or Report, select the field and open the properties list, under Format type mmm for short month or mmmm for long month.

I hope that has helped, regards Pete

Access tip:

Label printing

You can create a report in Access for printing labels All you have to do is is click New under the Reports object and then select Label Wizard and follow the steps

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.09 secs.