This event fires after the data is loaded and bound to the controls contained in a section, but before the section is rendered to the canvas.
The format event is the only event where the section's height may be changed. This section may be used to set or change the properties of any controls, or load subreport controls with subreports.
If the CanGrow or CanShrink property of any control contained within a section, or the section itself, is set to true, all of the growing and shrinking of controls contained in this section, and the section itself, takes place in this event. Because of this, information about a control or section's height cannot be obtained in this event.
Private Sub Detail_Format() ' If sales value is > 10000 Then color the field red If txtSales.DataValue > 10000 Then TxtSales.ForeColor = vbRed End If End Sub