Text box

[Impactgc]

I have hopefully a easy question... I have a text box for example...

"The charge for this item is:$25.00 ."

Now the $25.00 is a field in my table. I am combining the statements:
Me![test] = "The charge for this item is:" & [ItemCharge] & " ."

For some reason it is not formating that field.. Yes it is currency field and format with 2 decimal points..

by the way I am doing this in a report....

Any ideas ,
Thanks
Adam
[sig][/sig]

 

[dsi]

Try this;

Me![test] = "The charge for this item is: " & Format([ItemCharge], "$#,##0.00&quot [sig][/sig]

 

[Macromagic]

as above, but use the CURRENCY, to make the app, currency independent

e.g. format(1234.00,"CURRENCY&quot .. in US $1,234.00, but in UK £1,234.00