Date Format

[denilynn]

How can I format a date field so the result shows up as January 1, 2008
(month spelled out)? I'm using Access 2007 and the date field will be merged
into a Word document, which is where it actually needs to have the month
spelled out.

 

[Douglas J. Steele]

Create a query, and use the Format function (not the Format property) in the
query (with a format of mmmm d, yyyy).

Export the query, rather than the table.

 

[denilynn]

This will probably open up a whole new can of worms, but here's the scenario.
Information is being input into an Access form, which also includes the date
field I asked about. The fields in the underlying table are then being merged
into a Word document. Am I making this more difficult than it needs to be?
--
Thanks in advance for your time!
denilynn

Create a query, and use the Format function (not the Format property) in the
query (with a format of mmmm d, yyyy).

Export the query, rather than the table.

 

[Douglas J. Steele]

Do you mean that the date field isn't in the underlying table? The query can
include a reference to the control on the form (the syntax is
Forms![NameOfForm]![NameOfControl])

--
Doug Steele, Microsoft Access MVP

(no private e-mails, please)

This will probably open up a whole new can of worms, but here's the
scenario.
Information is being input into an Access form, which also includes the
date
field I asked about. The fields in the underlying table are then being
merged
into a Word document. Am I making this more difficult than it needs to be?