Colored datasheet ...

  • Thread starter Thread starter John Doe
  • Start date Start date
J

John Doe

Hello:

I have a form that displays the records in datasheet. What I could really
use is to color records based on criteria in the columns. If I have a field
called STATUS, all records that have "1" display the records as blue, all
those that have "2" display the record as red and etc. This would very well
look like a rainbow of records. Is something like this possible.


Regards,
Moi
 
Yes,

If it's a continuous form (I assume its is) then look up 'conditional
formatting' in help
or
Just click conditional formatting in the 'format' menu and have a play.

TonyT..
 
John said:
I have a form that displays the records in datasheet. What I could really
use is to color records based on criteria in the columns. If I have a field
called STATUS, all records that have "1" display the records as blue, all
those that have "2" display the record as red and etc. This would very well
look like a rainbow of records. Is something like this possible.
Click to expand...


Without a ridiculous amount of work, a rainbow is not
feasible on a form in either datasheet or continuous view.
You can use Conditional Formatting (View menu) to get a
default color and up to three other colors.

In single form view, you can use code to get more colors
than any user would find helpful.
 
Back
Top