Datasheet Back Color

M

Mary Fetsch

I'd like the background color of some fields in my datasheet to be gray. I
can set that back color property on each field, but in datasheet view, I only
see a white background. Same result if I set the field's back color in VB.
Is there any way I can get my gray?
 
A

Allen Browne

Use Conditional Formatting (Format menu, from form design).

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

Mary Fetsch

Thanks a lot! That solves my problem.

Allen Browne said:
Use Conditional Formatting (Format menu, from form design).

Set Condition 1 to:
Expression ... (True)
and choose the gray color in the bucket icon.
Click to expand...
 
Top