Date/Time Format Changes On Exporting

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

Guest

Using Office 2003
I am exporting a query to MS Word Merge File. In the query and its table,
date and time are formatted as medium. When I use the file for merge into
Publisher or Word, the date is short and time is long.

How can I keep the formatting from ACCESS?

Thanks
 
shep said:
Using Office 2003
I am exporting a query to MS Word Merge File. In the query and its
table, date and time are formatted as medium. When I use the file
for merge into Publisher or Word, the date is short and time is long.

How can I keep the formatting from ACCESS?
Click to expand...

Formatting with the format property is for screen display only. To export a
particular format you need to use the Format() function.
 
Thank you

Rick Brandt said:
Formatting with the format property is for screen display only. To export a
particular format you need to use the Format() function.
Click to expand...
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to Export Gmail Emails to PST Format? 4
Automate Change of the format of a field to short date for export 2
Which is the best MBOX Converter Tool different formats conversion? 4
Date format when exporting 2
Date Format when Exporting 5
Error Message after exporting MS Access Table 0
UK dates in database appearing as US dates in a mail merge document 2
Mail Merge with Word 3

Back
Top