Change row font color

H

Hugh

I am using Access 2000 and would like to change the font color of the first
three rows of a report to green. I am a novice when it comes to code writing
and would greatly appreciate help with this project. The rows consist of
Player names and their stats.

Hugh
 
H

Hugh

Thank you Rick, that works great. Is the extra TextBox there just for a
counter? I'm trying to understand how this code business works.

Hugh
 
H

Hugh

Rick,

I have one more problem that you may be able to solve for me. In the Header
of my report I have control to designate the particular course (Red, Green,
Orange) that we are playing for a given week. I have a table with just those
three entries called "Courses". I also have a table called "Schedule" that
has all the play dates and the "Course" that we play each week. I use a
query to extract the particular course for a given which passes the info on
to a subreport that places the course for that week in my report. I would
like the course name to be formatted the color of it's name, i.e., Green
course green font, Orange course orange font, etc. I tried using a similar
code like the one you gave me but to no avail:
If Courses=Green Then
Me.Courses.ForeColor=32768
Can you help?

Hugh
 
R

Rick Brandt

Hugh said:
Rick,

I have one more problem that you may be able to solve for me. In the
Header of my report I have control to designate the particular course
(Red, Green, Orange) that we are playing for a given week. I have a
table with just those three entries called "Courses". I also have a
table called "Schedule" that has all the play dates and the "Course"
that we play each week. I use a query to extract the particular
course for a given which passes the info on to a subreport that
places the course for that week in my report. I would like the course
name to be formatted the color of it's name, i.e., Green course green
font, Orange course orange font, etc. I tried using a similar code
like the one you gave me but to no avail:
If Courses=Green Then
Me.Courses.ForeColor=32768
Can you help?
Click to expand...

You need quotes around string values.

If Me!Courses = "Green" Then ...
 
Top