ROUNDING OFF VALUES IN A CONTROL

[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.

 

[Nikos Yannacopoulos]

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