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

[Tom van Stiphout]

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.

[Allen Browne]

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.

--
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.

"Tom van Stiphout" <no*************@cox.net> wrote in message
news:qq********************************@4ax.com...

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.

[Larry Linson]

"Tom van Stiphout" <no*************@cox.net> wrote

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