Copying data that has been formated

[Tpaairman]

I have a field that is a text calculation. What it does is takes several other field's info, and puts it all together here.

The problem is, two of my other fields are numbers, that have been formatted as currency, so they show the decimal places and a $ sign. But my calculation in the main field only copies the raw data. I want it to copy the $ and the decimal places.

[luggerite]

There may be a better way, but I'd structure the calculation to format the number as it calculates:

ie: Text + " $" + Round(Amount;2)

where "Text" is your other text fields and "Amount" is your currency field.

[luggerite]

Sorry, I should add that to always force 2 decimal places you need to either use a hidden calculation field that corrects the "Amount" as a properly formatted text string or use the following calculation in your field calculation:

Text & " $" & Round(Amount;2) & Case(Position(Round(Amount;2);".";1;1) = 0;".00"; Position(Round(Amount;2);".";1;1) = Length(Round(Amount;2))-1;"0";"")

Note I foolishly used "+" in my previous post when it should have been "&"..... :-(