Bold a control on a report

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

johnb - 09 May 2008 11:01 GMT

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

Reply to this Message

Mr B - 09 May 2008 14:37 GMT

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

Signature

HTH

Mr B
askdoctoraccess dot com

> 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
[quoted text clipped - 4 lines]
>
> john b

Reply to this Message

Mr B - 09 May 2008 14:41 GMT

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.

Signature

HTH

Mr B
askdoctoraccess dot com

> 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
[quoted text clipped - 4 lines]
>
> john b

Reply to this Message

johnb - 09 May 2008 15:18 GMT

Hi Mr B

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

john b

> johnb,
>
[quoted text clipped - 17 lines]
> >
> > john b

Reply to this Message

Mr B - 09 May 2008 15:23 GMT

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

> Hi Mr B
>
[quoted text clipped - 23 lines]
> > >
> > > john b

Reply to this Message