Another Conditional Formatting question

  • Thread starter Thread starter jonathan brown
  • Start date Start date
J

jonathan brown

I have a report that displays a simple contact list of
about 130 individuals. Some of the individuals are
considered "Site leaders" and others are not. I've
indicated in my database that an individual is a site
leader only by using a Yes/No checkbox with their record.
Is there a way in my contact list that I can set a rule
that states: If the contact is a site lead then Bold their
information?

Basically, I don't want to set any conditional formating
on one particular field. I want to bold the entire row if
that person is a "site Leader" or not.
 
jonathan said:
I have a report that displays a simple contact list of
about 130 individuals. Some of the individuals are
considered "Site leaders" and others are not. I've
indicated in my database that an individual is a site
leader only by using a Yes/No checkbox with their record.
Is there a way in my contact list that I can set a rule
that states: If the contact is a site lead then Bold their
information?

Basically, I don't want to set any conditional formating
on one particular field. I want to bold the entire row if
that person is a "site Leader" or not.
Click to expand...


There is no way to get Access to bold all the controls in a
section. You either have to set comditional formatting for
each control or you can use code to do it.

Dim ctl As Control
For Each ctl In Me.Section(0).Controls
If ctl.ControlType = acTextbox Then
ctl.FontBold = Me.SiteLead
End If
Next ctl
 
Back
Top