Alternate rows with bold font

  • Thread starter Thread starter *Glen*
  • Start date Start date
What do you mean "it still does not work"?

My guess is that the expression you are using for the backcolor is never
evaluating to true. Or, you might need to use a different
FormatCondition(#).

Did you get an error when you typed that line and hit enter?

Was the report in design view at the time? It needs to be.

Do you already have a condional format set for that control? If not, you
must first define a conditional format for the control. I chose to set it to
an expression that would always evaluate to True but if you are using this
for alternate row stuff, then you can use whatever expression you were using
for that. Once you have created that condition, then you should be able to
use that line of code to set the backcolor to the appropriate value.

Is the textboxes control name actually "personnel_2008" or is that the
control source for the textbox (or both).

Did you save the report after running that line
 
OK, lets try this.

Open the report in design view
Open the code window, and in the Immediate window type
?rgb(197,236,255)

Then hit enter. Now type:

?reports("reportname").Controls("control_name").formatconditions(0).backcolor

Then hit enter. What do you see on the line below the one you just typed?

Now type:

?reports("reportname").Controls("control_name").formatconditions(1).backcolor

Then hit enter. Copy everything in the Immediate window and paste it in a
response to this email.

Dale
 
Dale,

Thanks for your patience. I really appreciate your help. As requested,
here is what is displayed in the immediate window:

16772293
?reports("rptMatrix2_1").Controls("personnel_2008").formatconditions(0).backcolor
16777215
?reports("rptMatrix2_1").Controls("personnel_2008").formatconditions(1).backcolor

***When I hit enter after typing the last line above, a message box appears
saying "The format condition number you specified is greater than the number
of format conditions."

I hope you have a great new year and I am sure that if we get this resolved,
2010 will start off awesome for me. Thanks for all of your time!

Glen
 
Back
Top