ROUNDING OFF VALUES IN A CONTROL

  • Thread starter Thread starter 123
  • Start date Start date
1

123

Hi there,
Please help. We are stuck. We would like to know how to round off the value
of a control to the nearest dollar not only in display but also in value.
Please note that the value has to be rounded off that is if we are
calculating that total with another value, it should account the rounded off
value and not the original value.

TIA.
 
In form design, select your control, properties, events
tab, On change event: macro with action SetValue,
arguments:
Item [control]
Expression =Round([control])

where control = the actual name of your control.

HTH,
Nikos
 
Back
Top