Instead of Format Box you can use TRANSFROM() function in Expr Field i.e:
TRANSFORM(MyTable.MyField, "99,999,999."+REPLICATE("9",number_of_dec))
HTH
>Is it possible to call any function from the Format box of the Field control? Generally I specify the format like 99,999,999.999. Now I want to control the number of decimals depending on the currency. As fas as possible, I don't want to create 2 different controls with different format and use 'Print When' option. Is there any other way out?
>
>Thanks,
>Yashodhan.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
