Currency Field Not Translating

D

DS

I have a Currency Field That the Format is Currency.
This works fine.
However;
When I put it in an Expression it only shows it as such
$7.50 becomes 7.5 etc.
[ItemName]&" "&[Money]
What am I doing wrong?
Thanks
DS
 
R

Rick B

If you are putting the field value in a formula like that, then the "format"
is not used. You'd need something like...


=[ItemName] & " " & Format([Money],"currency")
 
D

DS

Rick said:
If you are putting the field value in a formula like that, then the "format"
is not used. You'd need something like...


=[ItemName] & " " & Format([Money],"currency")


---
Rick B



I have a Currency Field That the Format is Currency.
This works fine.
However;
When I put it in an Expression it only shows it as such
$7.50 becomes 7.5 etc.
[ItemName]&" "&[Money]
What am I doing wrong?
Thanks
DS
Click to expand...
Click to expand...
Rick, Your right on as Usual. Thank You
DS
 
Top