Need to set different Edit Mask, all numeric with or without decimal, for a field in a Tabular / Grid datawindow. Don't have a function like available for setting Format. Is that possible to set ?
The issue is for each row, user will be selecting the unit [ Numbers, Meters ... ] and then enter Opening Stock quantity in the next field. For the same item, there is a possibility of having more than one unit [ Meters as well as numbers ]. For meter unit, decimal value is allowed but NOT for numbers unit.
Sometimes, users tend to enter decimal values for numbers unit also. Instead of entering 24 they tend to enter 24.500. Due to format setting, the value shows without decimal, rounding to the nearest integer, as 25 in this case. And it cascade its effect to opening stock value, instead of 25 * Rate, it multiples 24.5 * Rate.
Setting EditMask could solve this issue, I think. Else other ways are there to avoid this wrong entry ?
EditMask setting got the following limitations.
- Only predefined format(s) are allowed. It didn't respect any other formats set.
- No provision to call any function, like available for format setting.
Any solution to this issue really appreciated.