MERGEFIELD syntax?

[Garry Jones]

Linking from Access to Word... (2003)

The following code works and writes the date in the way I want.

{MERGEFIELD "Date2" \@ yyyy/MM/dd}

The following adds a - before the field if it exists, but leaves the
date in the wrong format.

{MERGEFIELD "Date2" \b " - "}

The following code "should work" but does not, how do you use the \@
switch and the \b switch simultaneously

{MERGEFIELD "Date2" \@ yyyy/MM/dd \b " - "}

Am I missing something...?

Garry Jones
Sweden

 

[Rick B]

Sounds like you are asking questions about items in WORD, not in ACCESS. We
don't do that side of it here. You should post to the WORD newsgroup if you
want help with how to set up the merge fields in WORD.

Someone may answer you here, but you should get a much faster response in
Word.

 

[Albert D.Kallal]

I am going to suggest that you simply format the date text in your query in
ms-access, and then merge using that query.

This is MUCH better...(and, you don't have to go and change each word
document).

In the query Buidler go

MyDate: format([InvoiceDate], "yyyy/mm/dd")

Now, just merge on the query. To do that..the follwing should help:

for merging from ms-access, you can use my super easy word merge here:

http://www.members.shaw.ca/AlbertKallal/msaccess/msaccess.html