Bold a control on a report

[johnb]

I have a Form with 30 or so combo boxes. A button prints the form to a
report. When I make changes to the Form's data I Bold the changes on the
Form. How do I pass any combo boxes that I've formatted to Bold to the
report so they are printed in Bold on the report?

TIA

john b

 

[Mr B]

johnb,

In the OnFormat event of the section of your report where the control you
want to be bold try code like thid:

If SomeCondition = true then
Me.ControlName.FontWeight = 700
else

 

[Mr B]

johnb,

In the Format event of the section of your report where the control is that
you want to be bold try code like this:

If SomeCondition = true then
Me.ValueAcre.FontWeight = 700
Else
Me.ValueAcre.FontWeight = 400
EndIf

Supply your own criteria and use the name of your control names.

 

[johnb]

Hi Mr B

Thank you for your missive. I shall try out your solution

john b

 

[Mr B]

johnb,

Sorry for the double post, I accidently hit the wrong key and sent the first
post before I had completed writing all I wanted to say.

Good Luck with your project.

Mr B
askdoctoraccess dot com