Show European Currency as 00,00 ? in Report

  • Thread starter Thread starter Gina
  • Start date Start date
G

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
 
Perhaps try changing the Format property of the textbox in which you display
this value to this:
##0,00
 
Thanks Ken ....

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

Big Thanks !
Gina
 
Back
Top