Is it possible to modify a control on a form so that it shows to 2 decimal places only when required and show to 0 decimal places the rest of the time.
I'm working on our invoicing system and the field quantity.
99% of the time we are dealing with whole numbers and 2 decimal places is not required. However, every now and then we need to display decimals, i.e. 29.50.
I don't want to force 2 decimal places for all quantities because 10,000,000.00 just looks silly.
The only way I can think to do this is to have 2 copies of the quantity control and show or hide one or the other depending on if we are dealing with a decimal but I'm hoping there's a more elegant solution?
I'm working on our invoicing system and the field quantity.
99% of the time we are dealing with whole numbers and 2 decimal places is not required. However, every now and then we need to display decimals, i.e. 29.50.
I don't want to force 2 decimal places for all quantities because 10,000,000.00 just looks silly.
The only way I can think to do this is to have 2 copies of the quantity control and show or hide one or the other depending on if we are dealing with a decimal but I'm hoping there's a more elegant solution?