FormatValue Event

See Also    Examples    Applies To

Occurs when a value may be formatted.

Event FormatValue(intCol As Integer, varValue, rec As Recordset20)

atb_FormatValue(intCol, varValue, rec)

This event is fired, whenever the atb has to format a value in order to display it. You may modify the varValue parameter as needed. Note that atb does some formatting before raising this event (Numbers are converted to strings according to the NumericScale property of the corresponding Field). The intCol parameter holds the index of the column in the atb.Columns collection allowing you to identify the column. The rec property holds the recordset to which the corresponding field belongs. Be sure to use this information, because the FormatValue is used by the atb to format any columns in any records of the recordset, not only the ActiveColumn and the current record.

You may generate an enum using the Copy Enum button of atb's property page to identify intCol.