>Ed (and Tim as I think this is a good time to forward!) *bg*
>
>>Keep trying... 23.0714
>
>OOPS! Thanks Ed you are correct I did not allow for that and I should of!
>
>Tim.... You will have to add some logic to allow for this ( a zero in the first place after the decimal as per the keep trying line above ) to what I sent you. Sorry for any trouble, perhaps I at least got you started. It would also be proper to thank Ed Rauh for catching my gotcha.
>
>Anyway, I hope that WE helped! < VBG >
If it's simply a matter of display, and not an InputMask issue, as it appears in the original message, TRANSFORM() works fine:
TRANSFORM(43.070000) && 43.07
The problem is the display using the input mask with the "," formatting; it requires the use of a dynamic input mask to truncate the mask to do this. With a currency data type, it inserts a leading currency symbol, and adds the digit separator, but creates a trailing decimal display of fixed length. So I think he's stuck with the field display because of his input mask; there are other solutions for later display in a string, but not for his application here.