judyscofield
Programmer
I'm working on a datareport. The user can select Font attributes for particular fields before the report is run. I'm getting an all or nothing result on the output.
When I setup the report, I change the attribute when I initialize the report, moving through each of the controls to see what the user selected, the value being held in a table - example:
If rs2!rptColFontBold Then
drAdHocPortrait.Sections("Section1".Controls(x).Font.Bold = True
Else
drAdHocPortrait.Sections("Section1".Controls(x).Font.Bold = False
Endif
I've tried using x as the control value, and using the controls name in quotes. Whatever the last control is set to, the report prints all controls with that font attribute. What am I doing wrong?
When I setup the report, I change the attribute when I initialize the report, moving through each of the controls to see what the user selected, the value being held in a table - example:
If rs2!rptColFontBold Then
drAdHocPortrait.Sections("Section1".Controls(x).Font.Bold = True
Else
drAdHocPortrait.Sections("Section1".Controls(x).Font.Bold = False
Endif
I've tried using x as the control value, and using the controls name in quotes. Whatever the last control is set to, the report prints all controls with that font attribute. What am I doing wrong?