Number formating not correct when access merges with word doc

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When I export from Access, the currency formating is changed in the word doc.
I have verified in the access table and the formatting there is correct. It
basically removes the Dollar sign as well as removing the digit separater (,)
for the thousands. I have also verified in the Regional and Language options
and everything is fine there.
When I look at an exported table in text format, it is also okay. The
currency formatting simply changes when there is a merge with Word Doc.
Any suggestions on how to keep currency formatting?
 
Since you are merging with word why not set the format in the word field to
being the one you would like it to be via a switchoption. I know easy way out
but quick and clean.

hth
 
okay, how do i do that?

Maurice said:
Since you are merging with word why not set the format in the word field to
being the one you would like it to be via a switchoption. I know easy way out
but quick and clean.

hth
Click to expand...
 
David

If the option offered by Maurice (use switch settings in Word) are not
feasible, consider coercing your currency data into a text/string format
before exporting. That way, you are exporting the string containing the $
and , and ...

Of course, since that would be a string, you wouldn't be able to "do math"
on it in Word.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
okay, how do i do that???

Jeff Boyce said:
David

If the option offered by Maurice (use switch settings in Word) are not
feasible, consider coercing your currency data into a text/string format
before exporting. That way, you are exporting the string containing the $
and , and ...

Of course, since that would be a string, you wouldn't be able to "do math"
on it in Word.

Regards

Jeff Boyce
Microsoft Office/Access MVP
Click to expand...
 
In the query, use a function that converts-to-string.

In the field, instead of [YourCurrencyField], you'd use something like:

CurrencyString: CStr([YourCurrencyField])

Regards

Jeff Boyce
Microsoft Office/Access MVP
 
Hi David,

In your word document go the the specific field where the currency data is
filled.
Now press ALT-F9 this will toggle the field codes belonging to the fields.
You should see something like: {YourFieldname \* Mergeformat}

Change this to:

{Yourfieldname \# "€ #.##0,00"}

Where yourfieldname is the fieldname from the database and the currency
format should be changed to the appropriate format from your country. I
supplied the european format for the euro but if you want te replace it by
something other that can be done. A simple trick is to go to Excel, type a
number change this to the appropriate currencyformat you like. Go to Format
Cells and look under the custom format. There you will see the format you
have chosen. Copy this and paste this into the fieldcode from Word. Should do
the trick.

hth
 
Back
Top