Date

G

Gina

I am trying to make a long date print out on a document. I have the date set
to short date and it would print fine. I was asked to change how the date
prints to long date. I am having trouble getting it to print a long date. I
have my format set to long date and my input set to 99/99/0000;0;_. My
control sorece is send date. What am I doing wrong?

My form exports a document to word.
 
C

cram

Gina,
you can format the "date"-field on the print lay-out/design of your report
in the properties/format field
I understand you are NOTusing the "americam" format. Us following
notifications
dddd = day of the week as monday, thuesday....
ddd = day of the week as mon, tue....
mm= month as nummeric 01 for january
mmm= mont as january, february....
yy or yyyy for 10 or 2010
Separations can be used as / or - or simply a blank
"dddd dd mmm yyyy" will give you "monday 10 may 2010"
This normaly works independently the input of your date (which by the way in
fact is stored as a number in access).
Good luck
 
G

Gina

That didn't work. Everything looks fine on my form but when I click the
create button which exports all of the data to word. It shows the date as
05/13/2010. Any other suggestions
 
D

Douglas J. Steele

Sounds as though you're exporting the table.

Create a query, and use the Format function (not the Format property).

Export the query, not the table.
 
J

John W. Vinson

That didn't work. Everything looks fine on my form but when I click the
create button which exports all of the data to word. It shows the date as
05/13/2010. Any other suggestions

The Export will ignore the Format setting on the date/time field. What you can
do instead is export from a Query instead of directly from the table; in the
Query put a calculated field by putting

ExportDate: Format([send date], "Long Date")

and export that instead. You can also control the date format explicitly, e.g.
use a Format string like

"dddd mmmm d, yyyy"

to display "Thursday May 13, 2010". Dig down in the Help for "Format" for
custom date formats, they're very flexible.
 

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

Top