Show European Currency as 00,00 ? in Report

[Gina]

Hi.

I am trying to show the value of a currency field (format as euro) in a
report.
all fine as long as it isn't e.g. 41,60 ... then it turns to 41,6 in the
report .... I use the expression builder for creating the whole text
(containing the various field values)

I tried ZCurrency(xx) the I get 41.6 ... which is even worth

what I am doing wrong (I use access2000 german version)

Thanks for any input

Gina

 

[Ken Snell [MVP]]

Perhaps try changing the Format property of the textbox in which you display
this value to this:
##0,00

 

[Gina]

Thanks Ken ....

I formatted the field as you suggested works just perfect!!! in my
concatenated text thing
)

Big Thanks !
Gina