Change a report font based on a field.

[Steve Hart via AccessMonster.com]

Hi,

I've built an Access 2002 DB that I use for my Old Time Radio shows. I have
a report that list of all the shows for a given series including broadcast
dates, episode numbers, titles and the like.

The query that the report pulls from also has other fields including a
Boolean field that says whether I have the show in my collection or not.
I'm adding that field to my report.

What I would like to do is change the font on the report to bold on the
episodes that I have. If the boolean is true, then the font will be bold,
if the boolean is false then the font will be normal.

Is this possible?

 

[Terry]

Steve,

In design view select the control (field) you want bold
and use "conditional Formatting" (in the format drop down
list).

This only became available in, I think, Access 2000 and
later. If you are running an older version post back.

HTH

Terry