Tadpole said:
In my mailmerge how do I make the currency field show 2 decimal
places as it is in Access Database? regards Tadpole
This is really done in Word not Access
Format merged data
To format merged data, you must format the merge fields in the main
document. Don't format the data in the data source, because its formatting
isn't retained when you merge the data into the document.
In the main document, select the field containing the information you want
to format, including the surrounding merge field characters («« »»).
On the Format menu, click Font, and then select the options you want.
Note If you're creating envelopes, you can also choose the delivery
address font while you're setting options on the Envelope Options tab during
the mail merge.
Formatting by using field codes
To control other aspects of formatting, press ALT+F9 to display field codes,
and then add switches to the merge fields.
For example:
To display the number "34987.89" as "$34,987.89," add the Numeric Picture
switch (\#).
To print client names in uppercase letters, add the Format switch (\*).
To ensure that the merged information has the same font and point size you
apply to the merge field, add the \* Charformat switch.
This is a newsgroup dedicated to questions about Access, the database
program in Office Professional. It appears your question may not be related
to these subjects. The Microsoft help system is not all that clear and may
have misdirected you here.
It is best to ask your questions in a newsgroup dedicated to the
subject of your question. You should find people better able to address
your problem there.
Note: It is always best to indicate the name and version of any
program(s) you may be using when asking a question and also indicate the
operating system (like Windows XP or 98) when you ask a question.
