macro transfer text

[Pamela Creighton]

I have a macro I created to transfer text
Transfer Type Export Word for Windows Merge
qryname
file name
has field names no

the problem is the qry has a date field in short date format 9-Jul-2006
however when exported it shows up as 7/9/2006 0:00:00

how can I get it to show in same format at qry or at least not show the
time, this is used for a large mail merge in word.

all help greatly appreciated hope I picked the correct newsgroup (did not
see one for macro)

 

[John Vinson]

I have a macro I created to transfer text
Transfer Type Export Word for Windows Merge
qryname
file name
has field names no

the problem is the qry has a date field in short date format 9-Jul-2006
however when exported it shows up as 7/9/2006 0:00:00

how can I get it to show in same format at qry or at least not show the
time, this is used for a large mail merge in word.

all help greatly appreciated hope I picked the correct newsgroup (did not
see one for macro)

TransferText ignores any formats set on table fields.

What you can do is create a calculated field in your Query:

ExpDate: Format([datefield], "Short Date")

and export that rather than exporting the datefield itself.

John W. Vinson[MVP]

 

[Pamela Creighton]

worked like a charm thank you for the quick reply.

I have a macro I created to transfer text
Transfer Type Export Word for Windows Merge
qryname
file name
has field names no

the problem is the qry has a date field in short date format 9-Jul-2006
however when exported it shows up as 7/9/2006 0:00:00

how can I get it to show in same format at qry or at least not show the
time, this is used for a large mail merge in word.

all help greatly appreciated hope I picked the correct newsgroup (did not
see one for macro)

TransferText ignores any formats set on table fields.

What you can do is create a calculated field in your Query:

ExpDate: Format([datefield], "Short Date")

and export that rather than exporting the datefield itself.

John W. Vinson[MVP]