Hi,

I am trying to get a currency held in a VB variable from an access database to move accross to MSWORD and keep the decimal point and commas in the bookmark.

If i try to transfer over 15.36 for example i get the decimal point, but for numbers like 150.00 once put into MSWord i get 150.

Is there any way to keep the decimal places even if its 0 and add the comma's in automatically. It can be hardcoded in using strings but i think there must be a much simpler method of achieving the same result.

Hi

Have you tried formatting the value using the Format function to get what you want?

Peter Mo.