How to Change Datasheet View Colum color?

[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

 

[Allen Browne]

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.

 

[Guest]

Hi, Will.

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

Sprinks

 

[Brendan Reynolds]

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.