Format Bookmarks to Euro Currency

[silentwolf]

Hi guys,

I guess it is a simple question and answer but I can not get it to work.

I like to use bookmarks to fill a word ducument but need Euro Currency for the amount.

        .Bookmarks("vv_AppBrutto").Range = Me.txtAppBrutto.Value

this is what I got at present.

How do I need to change it so it shows for example € 750,50.-

Many thanks

Albert

 

[Gasman]

Format for your Currency?

 

[silentwolf]

Yes Gasman

Euros in my case )

 

[MajP]

.Bookmarks("vv_AppBrutto").Range = Format(nz(Me.txtAppBrutto.Value,0),"Currency")

 

[silentwolf]

Hi MajP,

many thanks for your help that is it!!
Fantastic!
I found Format and Currency but not the whole statement!

Cheers!

Albert