Forcing decimal points
I have a text field where I display USD when we have a US customer and simply a dollar sign infront of the the total when we deal with our canandian customers.
If (InterimContacts::Currency = "USD"; "USD$" & Round(SubTotal+LevyCalc+PriceAdjustment;2); "$" & Round(SubTotal+LevyCalc+PriceAdjustment;2))
The problem with my formula is that I used to use the data formatting in the inspector to force fthe required decimal points and left the feidl as a number field. I've now been asked to include the USD and can seem to narrow it down just right.