TC said:
how would one go about formating a report a runtime. I have a sub report
and depending on how many records are returned i want to change the font
size of the text field.
If I understand the question?? you can use the subreport's
header section's Format event to change the detail control's
font size:
If Me.txtRecords > 5 Then
Me.textbox1.FontSize = 10
Else
Me.textbox1.FontSize = 12
End If
where txtRecords is the name of a text box in the report
header section with the expression =Count(*)
Note that this will not make the subreport take up less
space unless you also set the detail controls' and sthe
detail section's CanShrink to Yes.
