Windows Vista 
Access 2007
I have an Access database (2007 Version) of names/contact info, etc for a membership database of a labor union. The database table includes current as well as past members. I then use a query to pull out just the current members and almost all of my reports are attached to that query. The main report I print from this query is a roster of current members who are available for work.
One of the fields in the database (and query) is "Safety." If a member has taken our safety course, that field is marked with a "*" and that "*" prints out beside their name on the report/roster. Unfortunately, the "*" is not as eye catching as we would like (even though it is set up as a larger font than the remainder of the report). My boss has recommended that we make the names of those who have attended the course show up in bold on the report and not use the "*" on the report. (I realize I need to keep the field in order to differentiate between those who have and who have not taken the course. It is not currently set up as a Y/N field, but can easily be changed if necessary. We just wanted a "*" by the name instead of a "Y" on the reports.)
This is my dilemma. How do I get some names in a field to appear bold, but not all names? I know how to go into the Design View and make that field bold, but that of course, makes all names appear in bold. I'm not even sure if making individual names appear bold is something that would be done on the report design or if it would have to be in the query design or even in the table design. I do use the table and query to pull other reports and don't necessarily want certain names bolded on those reports, so am hoping it is just a matter of changing something in that specific report's design itself.
Reply With Quote
