Trailing zeros in Access currency field will not export to Word

[MacroScope]

I've written a database in Access for an insurance company which ultimately exports the data from Access to Word to fill in a quotation for the customer. Everything works well, with 30 or more fields exporting correctly. My issue is with an Access currency field.

In the table that holds the data to be exported, there might be a value such as $97.20. Within the table, the amount is formatted correctly. However, upon export to Word it becomes $97.2 and the final zero is dropped.

How can I format the Word field to leave the final zero in place? I'm working with Office 2007 on this one.

 

[GaryCanuck]

Sounds like you need to use switches. Assuming it is Word "Fields" that you're using. Right click the field and click edit then add the appropriate switch. Something like \# ",0.00". See

http://www.gmayor.com/formatting_word_fields.htm

Cheers.

 

[MacroScope]

Thanks. I'll check it out the next time I'm there. It seems to be something simple, and hopefully this will cure it!