How to Change Datasheet View Colum color?

  • Thread starter Thread starter Will
  • Start date Start date
W

Will

I have a Form that displays selected fields of each record as a row in
Datasheet View.

I want to color one column... the column the client double clicks to open a
form showing the complete Record.

The properties for the Datasheet View Form don't seem to work?

Is there a way to color individual columns for a Form displayed in Datasheet
View?

thanks for any help.

Will
 
It is possible (if a little eccentric) to change the background colour of
one column in datasheet view of a form with conditional formatting.

1. In form design view, select the column to be changed.

2. From the Format menu, choose Conditional Formatting.

3. Set Condition 1 to:
Expression Is True
and choose the color (in the bucket icon.)

If you need to do it programmatically, you can set the FormatCondition of
the text box.
 
Hi, Will.

Datasheet view is limited. You can, however, do this in continuous form view.

Sprinks
 
You could use conditional formatting. Choose an expression that you expect
to always be true, e.g. for a text field, Field Value Is not equal to
"Jabberwocky" or something equally unlikely to occur in the real data.

Using the Default Formatting option of conditional formatting would have
been a more elegant solution, but it doesn't appear to work in datasheet
view.
 
Back
Top