>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, both the properties Format and Inputmask are at your service. E.g.:
Grid1.Column1.Text1.Format =
Grid1.Column1.Text1.Inputmask =
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.