Long Date format without day of the week

[Candice]

How can I format a date to appear 'Month Day, Year' (ie. May 20, 2008)? The
closest I can find is the Long Date format (ie. Tuesday, May 20, 2008), which
includes the day of the week. How can I exclude the day from the format?

What input mask would reflect the same date format?

I use this date field with Mail Merge in MSWord and need the date to import
as indicated above.

 

[Douglas J. Steele]

You're not limited strictly to the named formats. Set your format to:

mmmm dd, yyyy

 

[Jerry Whittle]

First off the format has nothing, absolutely nothing with how date and time
data is stored in an Access database. Actually it's stored as a number.

For example May, 20 2008 is actually stored as 39588.

5/20/2008 12:55:23 PM is stored as 39588.5384606481.

Format is how that number is displayed. Therefore an input mask for a
Date/Time field would make no difference in how the data is displayed short
of requiring or preventing the time from being entered.

In a query you could use something like below to display the date as you wish.
TheDate: Format([TheDateField], "MMMM, DD YYYY")

In a form's field the format would look like so:
mmmm", "dd yyyy