Highlighting every other row, more

  • Thread starter Thread starter Janet
  • Start date Start date
J

Janet

Steve Schapel provided an answer to my question about how
to highlight every other row in a report with a gray
background. The suggestion was to add an unbound text box
named RowCounter that covered the entire section with the
control source set to =1 and to set its running sum
property to overall. Then, format the text box to "Send to
back" with conditional formatting as Expression is:
RowCounter Mod 2 = 1. I liked the suggestion, but when I
tried implementing the suggestion the conditional
formatting didn't work. I entered the expression just
like he said, but it was changed from RowCounter Mod 2 = 1
to "RowCounter Mod 2" = 1.

I'm pretty sure I did everything just like he said, but it
didn't work. It sure sounded logical. I tested the Mod
function in a spreadsheet and I see why the idea should
have worked. It seems, however, that the syntax must be
wrong, or I did something to make the correct syntax not
work.

Any ideas? I really appreciate your help.
 
Janet said:
Steve Schapel provided an answer to my question about how
to highlight every other row in a report with a gray
background. The suggestion was to add an unbound text box
named RowCounter that covered the entire section with the
control source set to =1 and to set its running sum
property to overall. Then, format the text box to "Send to
back" with conditional formatting as Expression is:
RowCounter Mod 2 = 1. I liked the suggestion, but when I
tried implementing the suggestion the conditional
formatting didn't work. I entered the expression just
like he said, but it was changed from RowCounter Mod 2 = 1
to "RowCounter Mod 2" = 1.
Click to expand...

It appears that CF doesn't recognize control names by
themselves. Try the expression:
Report.RowCounter Mod 2 = 1
 
Back
Top