Can you BOLD a field's text based on another field value?

[fivespeedv8]

In my club membership database, I would like
to BOLDFACE the info for members who are
OFFICERS in the club. I have a field called
MemberRole which is a Value list, with
several choices in the pulldown pick list
upon data entry. They Row Source values are
such things as "President" "Treasurer" and
"Regular Member"

I am working on a report that prints
the club roster, and I'd like to know if
there is a way to make the member's name
and contact info to appear in BOLD TYPE
if the ROLE is one of the officers.

 

[Lyn Mac]

Assuming that President and Treasurer are Officers and Regular Member are not.

In the format or print event of your report try:

If Me.MemberRole = "President" Or Me.MemberRole = "Treasurer" Then
Me.MemberRole.FontWeight = 700 'Bold
Else
Me.MemberRole.FontWeight = 400 'Normal
End If

Lyn