Colored datasheet ...

  • Thread starter Thread starter John DOE
  • Start date Start date
J

John DOE

Hello:

Usng Access 2003 I have a few forms that I have setup as datasheets. I am
sure that I am not that unique that I would like records colored based on
say a field. Maybe I should elaborate ... working in the trucking dispatch,
we have different statuses for containers ( empty, import, export, etc. ).
I can change the status of the container in a status field. Now, in my
datasheet, based on that number ( 1 thru 9 ) I would like them colored As
bizarre as it might look, it would give lots of different colors. Is this
possible based on 1 field and if so, can someone lead me in some direction
please.


TIA
 
Hello:

Usng Access 2003 I have a few forms that I have setup as datasheets. I am
sure that I am not that unique that I would like records colored based on
say a field. Maybe I should elaborate ... working in the trucking dispatch,
we have different statuses for containers ( empty, import, export, etc. ).
I can change the status of the container in a status field. Now, in my
datasheet, based on that number ( 1 thru 9 ) I would like them colored As
bizarre as it might look, it would give lots of different colors. Is this
possible based on 1 field and if so, can someone lead me in some direction
please.


TIA
Click to expand...

Use a Continuous Form rather than a datasheet, and use the Format...
Conditional Formatting menu option.

John W. Vinson [MVP]
 
I belive the OP wants 9 different options.
With conditional formatting, you can have only 4 choices. The format at
design time and 3 different conditions that can be applied.
 
I belive the OP wants 9 different options.
With conditional formatting, you can have only 4 choices. The format at
design time and 3 different conditions that can be applied.
Click to expand...

ahhh... thanks Dave, missed that.

One thing I've done is to conditionally-format TWO controls. You could have
three colors each to get red-red, red-green, red-blue, green-red, green-green
and so on. Nine colors will challenge the colorblind of course...

John W. Vinson [MVP]
 
Back
Top