Currency Formatting in a report 1

[postmanphat]

Hi,

I've got a report that has a text box with the following control source:

=Trim("You have been awarded £" & [totalawarded] & " from the YSA.")

which displays this:

You have been awarded £1500 from the YSA.

The problem is that I really need it to show this:

You have been awarded £1500.00 from the YSA.

The field is set as currency in the underlying table and when you look at the query results in the query that the report is based on, it gives the value as '£1500.00' but on the report only gives the value '1500'. Obviously I can't just format the field on the report because its got all the other guff in there.

Any advice would be most appreciated.

Thanks

 

[jrbarnett]

=Trim("You have been awarded £" & Format ([totalawarded], "0.00") & " from the YSA.")

John

 

[postmanphat]

John - I love you.