Concatenation and Currency

[Tedski]

I have 2 fields in my book database, Condition and Price. I have the Price
field set as Currency. However when I join the two fields in my report, the
price displays as a number, e.g. 6.5 instead of $6.50. I am using the
expression, =[Condition]&" "&[Price].

Where am I going wrong?

Thanks.

 

[fredg]

I have 2 fields in my book database, Condition and Price. I have the Price
field set as Currency. However when I join the two fields in my report, the
price displays as a number, e.g. 6.5 instead of $6.50. I am using the
expression, =[Condition]&" "&[Price].

Where am I going wrong?

Thanks.

Once a number field is concatenated with a text field, the number
field looses whatever number format it has, as it is now text.

=[Condition] &" "& Format([Price],"Currency")