I have several fields in a form with data type decimal(25,8). When bound to an edit component in the form, all 8 decimal positions are displayed, even if 0. I would like to format the edit for decimal(25,2) but keep decimal(25,8) as the data type in SQL and the IDO.
I tried playing with the Data Type properties in Designer, but it looks like only Length can be changed as Decimal Point Position is disabled.
How do we round/format decimals in the form without having the change the IDO/SQL data types?
