Quote:I tried using this, but it did not make any difference.
If not @isblank(Qty) then
Cost = @tm(Qty) * Item Cost
If @isblank(Qty) then clear(Cost)
That should work. I just cut and pasted your sample into my test app, modified the names, and it works. Are you sure you saved the design before previewing?
In any case, that doesn't matter because you can simply reformat what you have now, to look the way you want.
Follow these steps:
1. Open the form in designer.
2. Click on the Qty element.
3. Click on the FORMAT tab under PROPERTY EDITOR.
4. In the DISPLAY FORMAT drop-down, select CUSTOM FORMAT.
5. Set DECIMAL PLACES to what you want (probably 2).
6. Leaving the CURRENCY SYMBOL box blank, click on the down-arrow, then on SET CURRENCY SYMBOL.
7. Change GROUP DIGITS to NO if you want.
8. Click on the Qty element, and type 1.25, then press Enter. (This is optional, but it will let you see the results right away, without needing to preview. If you make any other changes to the properties, you will need to change a digit or 2, for it to update with the new format.)
9. Once you have it the way you want, don't forget to SAVE the design.