Currency Field Not Translating

  • Thread starter Thread starter DS
  • Start date Start date
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
 
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 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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access Field won't show as currency in the form, shows just a number (but works fine in the query) 1
Currency changes when merging to Word 2
amount field not showing currency format 3
How do you refer to a null field in a UDF 1
Lookup query allows me to retrieve up to two rows. 1
Format Currency as Accounting 2
Currency 2
Brendan Reynolds rounding module 1

Back
Top