Formatting the Date differently in mail merge

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a feild in a mail merge that is in the date format "##/##/####", but I
want to change it to a longer format like, Month, Day, Year. I don't want to
change the actual format of the original feild so that it is easier to input
data, but wanted printed out differently in the mail merge.

Thanks for your time.
 
William,
Once a date has been stored... in any legitimate format, you can reformat it on the fly
in any subsequent form, query, or report, without affecting the stored value.
On your report, try a Format of...
mmmm d, yyyy
would yield January 12, 2007 or March 1, 2006 ...etc...
See Format Help for other variations.
--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."
 
That looks like an input mask, which is not quite the same thing as format.
The input mask is to provide a framework for the data entry, often to assure
that the data is in a legitimate format (no 4-digit Zip Codes, for
instance). Some input masks require that a particular number of characters
of a particular type (letter, digit, etc.) be input. Format, as explained
in the other response, controls how data are displayed.
 
William

Just to clarify, are you creating a Word Mail Merge document linked to
a table (or query) in an Access database and you want to format a date
field in the Word document to show as mmmm d, yyyy.

You would probably get an answer from the Word newsgroup but have a
look at http://word.mvps.org/FAQs/MailMerge/index.htm which shows how
to format mail merge date type fields in Word.

HTH

Peter Hibbs.
 
Back
Top