Access to Word mail merge (1 Viewer)

[GBeck]

I have a merge field in my word doc, and when I merge from access how would you keep the currency format that I need?
and I have tried {\# $####,##.00} and it didn't work, with the first bracket before the merge field.
Any help would be great.

 

[GBeck]

in case anyone needs this I thought I'd leave the post, but this works.
create you merge field
hit shift F9 on the merge field
and type { ={mergefield cost \* mergeformat} \# "$#,###.00}

where cost is the name of the merge field

 

[ansentry]

From help in Word 2003

For example:

To display the number "34987.89" as "$34,987.89," add a numeric picture switch (\# $#,###.00).
To display the number "0945" as "9:45 PM," add the date/time picture switch (\@ "h:mm am/pm").
To ensure that the merged information has the same font and point size you apply to the merge field, add the \* MERGEFORMAT switch.

Another on that can give you problems is the date format (If you done use the US Format - which I don't)

{MERGEFIELD "PartCost" \@"dd-MMM-yyyy"}

If you type Picture Switches into Word help you will get them all;

 

[GaryPanic]

ok-coming in on the end of this

this is the correct switch for currency conversion

reasoning behind this is that the currecny should be a merge field from Access ie Sterling £ or Euro € or Dollar

so "currencymergefield" (space) "mergefield\# #,##0.00"
the below being the switch
\# #,##0.00

now if you only deal in one currency then formating the switch to $/£/€ is fine - but a global approach allows for further development ...