Prev: Print Report Landscape
Next: No Current Record Error
From: Robin on 14 Apr 2010 10:37
Hi. I have created a crosstab report and I would like to color some cells a
certain color and others a different color. I can color a whole row or a
column easily enough, but not individual cells. The color will depend on the
name of the row or the column. I am assuming that this cannot be done, but
it would be great if it could. Any ideas?
Thanks!
From: Duane Hookom on 14 Apr 2010 18:01
There are no "cells" in Access. I assume you mean text boxes. You can add
code to the On Format event of a section to change almost any property of a
text box.

--
Duane Hookom
Microsoft Access MVP


"Robin" wrote:

> Hi. I have created a crosstab report and I would like to color some cells a
> certain color and others a different color. I can color a whole row or a
> column easily enough, but not individual cells. The color will depend on the
> name of the row or the column. I am assuming that this cannot be done, but
> it would be great if it could. Any ideas?
> Thanks!
From: Faith &hope on 15 Apr 2010 17:23
When you select your cell try to use control.
I think this can Help you.
Thank you.

"Robin" <Robin(a)discussions.microsoft.com> wrote in message
news:D4B448D5-9A30-4A81-99D4-808C663F0CE1(a)microsoft.com...
> Hi. I have created a crosstab report and I would like to color some cells
> a
> certain color and others a different color. I can color a whole row or a
> column easily enough, but not individual cells. The color will depend on
> the
> name of the row or the column. I am assuming that this cannot be done,
> but
> it would be great if it could. Any ideas?
> Thanks!

 | 
Pages: 1
Prev: Print Report Landscape
Next: No Current Record Error