I could use some help with this access/word whackiness

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

DevArrah - 05 Dec 2004 17:29 GMT

I'm trying to merge some currency field into a document.
In the document as it stands, the figures will show up correctly, i.e.
$14,112.30 for instance

but then I saved the word document under a different name and added the
same query as the data source but when I insert the mergefield i get
unformatted numbers i.e. 14112.30. The weird thing is when I reconnect
the query, it'll lose for formatting to.

I've looked in the help file of word
I've looked at the field codes for mergefield

and I can't see how the first document is formatting the number

Can anyone offer a suggestion on how I can retain the currency
formatting in the mergefield automatically?

Reply to this Message

Peter Jamieson - 06 Dec 2004 09:25 GMT

It could be that the first document is getting its data from Access using
DDE (particularly if it was originally created using Word 2000 or earlier)
and the second one is using ODBC, or more likely, OLEDB (Word 2002 and
later).

If Access actually starts when you open the first document but not when you
open the second, that is almost certainly the explanation.

To change the way Word connects in Word 2002/2003, check Word
Tools|Options|General|Confirm conversions at open, then go through the
connection process again and choose the one you want when offered.

If it isn't that, I don't know what the difference is.

Peter Jamieson

> I'm trying to merge some currency field into a document.
> In the document as it stands, the figures will show up correctly, i.e.
[quoted text clipped - 12 lines]
> Can anyone offer a suggestion on how I can retain the currency
> formatting in the mergefield automatically?

Reply to this Message

DevArrah - 07 Dec 2004 00:38 GMT

> It could be that the first document is getting its data from Access using
> DDE (particularly if it was originally created using Word 2000 or earlier)
[quoted text clipped - 11 lines]
>
> Peter Jamieson

Thanks :)
I dunno if that was it but I fixed it by using the general switches i
learned about from the thread below mine :)

Reply to this Message