>Hello all,
>
>I am struggling for some time know with the formatting of the currency datatype in a grid. By seeting the format to "$" and the inputmask to "999.999,99$", i get the rigth formatting, but only if the textbox has the focus. If it doesn't, it still has the standard currency format.
>
>so a value of 50$ shows as 50.0000 when the textbox doesn't has the focus, and $50.00 when it is selected. is there any way that i see only the "$50.00" format at all the time?
>
>greetings,
>
>
>vincent
Vincent,
(1) if the textbox has an inputmask, set the column.Sparse = .F.
or (2)
Set the DynamicInputMask of the column to '999,999,999.99' for EUR and '99,999,999,999' for BEF.
Or '@Z 999,999,999.99' for EUR and '@Z 99,999,999,999' for BEF in order to not display zero values
If the column can hold both BEF and EUR (eg all invoices for a client), you need a currency indicator per line/record.
Then :
Grid.Column12.DynamicInputMask = [iif(Table.Currency_id =='BEF', '99,999,999,999', '999,999,999.99' )]
Gregory