>I am trying to display large integers from a field(from a table) bound to a controlSource of a textbox on a grid. The numbers are in stored in millions (i.e 17,665,837.12) that I would like to display in the grid column as 17.66 (in millions). Is there a Format/Input Mask property setting that accomplishes this?? Right now the ControlSource is set to : v_table.nAmount. Will the controlsource property accept an expression (v_table.nAmount/1000000) ?? TIA
Ed,
Yes. But I believe that you have to precede the expression with = if you do it in the form designer
eg : = round(v_table.nAmount/1000000, 2)
Gregory