Bold a control on a report


J

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
 
Ad

Advertisements

M

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
 
M

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.
 
J

johnb

Hi Mr B

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

john b
 
Ad

Advertisements

M

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bold 1 or many fields in a report 3
change font to bold on tab control 1
Bold 2
Bolding words 1
Flashing Bold 1
Making text BOLD 4
Setting text in bold 3
Bold results of query 0

Top