Change a report font based on a field.

  • Thread starter Thread starter Steve Hart via AccessMonster.com
  • Start date Start date
S

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?
 
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
 
Back
Top