Mail Merge Problems

[Mooresy]

Hi,

I'm looking for a bit of advice on a simple invoicing program i have started modifying. I'm an Access amateur and have done a bit of coding so know the basics.

I had a few problems that ive managed to iron out. Theres only one issue now, word doesnt display the full currency.

i.e.

in Access - £199.99
~


in Word - 199

To my knowledge, i have tried and come to the conclusion that i am unable to use a Numeric Picture Switch as all this will do is round up and down which is not an option as prices must be bang on to the pence. I have read something about compatabillity issues between Office 02 and 07 and the solution was through DDE instead of OLE DB, can you advise me how i can force Word to use the DDE conn method so that all formatting is included??

[SoftwareMatters]

You could format it as a string something like this:
Dim MyString as String
MyString = "£" & CStr(Format(nz([CurrencyField],0),"0.00"))

[Mooresy]

hi, sorry for the late reply been out of the office over the weekend. I can see how that would work and would like to give it a go, although as i said i'm a bit of an amateur! Where would i place the code? In the 'on_click' section of the 'print' invoices' button?

Cheers,

Adam

[SoftwareMatters]

It would probably be best to add it to the query used by the mailmerge.
So, open the query in design view.
In the currency column you need to add this in the field row:

ColumnName: "£" & CStr(Format(nz([CurrencyField],0),"0.00"))

NB: you need to replace "ColumnName" with whatever name you want (this will be picked up in the mailmerge) and replace "CurrencyField" with the name of the actual currency field.