Number format won't keep when doing mail merge

[sophy]

Hi all --

I am running a simple query with a purchase price field which I use to mail merge into a Word document. I've got my purchase price field in the table AND query as a currency format, BUT, when it merges into Word, it comes out as plain old "2500" rather than "2,500.00". Is there an easy way to preserve the format when it mail merges into Word?

Appreciate any help you can offer.

Cheers, S.

 

[dhookom]

Use a query as your data source for the merge and change your currency field column to something like:
CurAmount: Format([CurField],"Currency")


Duane
MS Access MVP
Find out how to get great answers faq219-2884.

 

[sophy]

Duane!!!
It worked!!!! Thank you! Thank you! Thank you!

Cheers, S