Set background color of a column in a subform in datasheet view

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Tom van Stiphout - 05 Jan 2006 04:46 GMT

Hi All,

Access 2003.
I would like to indicate required fields with a special background
color. Easy for parent forms, but I also have several subforms in
datasheet view. For those, I would like to color the vertical column
in the special background color. The Infragistics grid control can do
that for my VB6 applications.

Am I correct in assuming Access can't do this?

Things I tried that don't seem to be the answer:
Format > Datasheet works for the subform as a whole.
Conditional formatting (CF) works at the row level. Perhaps it can be
rigged to do what I want. Another concern about CF is that it
noticably lags behind the form display.

Thanks,

-Tom.

Reply to this Message

Allen Browne - 05 Jan 2006 05:14 GMT

Tom, AFAIK, conditional formatting is the simplest option.
Use:
Expression True
and the expression will be true for all recrords.
There still is a delay.

If there is another possibility, www.lebans.com would be the place to find
anything graphical like this.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi All,
>
[quoted text clipped - 16 lines]
>
> -Tom.

Reply to this Message

Larry Linson - 10 Jan 2006 03:21 GMT

> Access 2003.
> I would like to indicate required fields with a special background
> color. Easy for parent forms, but I also have several subforms in
> datasheet view. For those, I would like to color the vertical column
> in the special background color. The Infragistics grid control can do
> that for my VB6 applications.

Tom, I suggest you not, repeat not, use datasheet view.

Use continuous forms view, and since it is entire columns you want to color,
you can set the BackColor property for the partcular Control. The problem
with using BackColor is that it will apply to every visible instance of that
Control... e.g., you can't make it apply to just selected Rows, but it
_will_ apply to the whole Column.

Larry Linson
Microsoft Access MVP

Reply to this Message