If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Change a report font based on a field.
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? -- Message posted via http://www.accessmonster.com |
#2
|
|||
|
|||
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 -----Original Message----- 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? -- Message posted via http://www.accessmonster.com . |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Office 2003 installation problem, log file attached.... | Ryan | Setup, Installing & Configuration | 0 | January 20th, 2005 06:57 PM |
Can't change font size in HTML-formatted messages being sent | Norm Dresner | Outlook Express | 9 | January 16th, 2005 11:06 PM |
Default font - possible bulletproof fix in Word 2003 | [email protected] | General Discussion | 0 | January 14th, 2005 09:14 PM |
conditional Change of field properties in a report | Frank | Setting Up & Running Reports | 3 | January 6th, 2005 08:56 PM |