Color a datasheet subform

[Robert]

How can I change a datasheet subform from white to a color. I changed the
back color of one of the textboxes in design view but it still shows white
when I open the form. The subform is disenabled and I need some way of
making it look disenabled.

Robert

 

[fredg]

How can I change a datasheet subform from white to a color. I changed the
back color of one of the textboxes in design view but it still shows white
when I open the form. The subform is disenabled and I need some way of
making it look disenabled.

Robert

Open the form in Form View (not design view).
Select any field in the subform datasheet.
Click on Format + Datasheet
Select the color from the Background color drop-down.
You might like Silver.
Save the changes.

 

[John W. Vinson]

How can I change a datasheet subform from white to a color.

You can't. Datasheets are not very flexible.

I changed the
back color of one of the textboxes in design view but it still shows white
when I open the form. The subform is disenabled and I need some way of
making it look disenabled.

Make it a Continuous form rather than a Datasheet; this gives you a lot more
control, such as using Format... Conditional Formatting, and it can be made to
look very much like a datasheet if that's what you want. The only thing you
can't do is dynamically resize the columns.

John W. Vinson [MVP]

 

[Robert]

An interesting suggestion. It might solve my other problem (see the post
above this one). But I've already changed the color.

 

[Robert]

Thank you.

Open the form in Form View (not design view).
Select any field in the subform datasheet.
Click on Format + Datasheet
Select the color from the Background color drop-down.
You might like Silver.
Save the changes.

 

[John W. Vinson]

An interesting suggestion. It might solve my other problem (see the post
above this one). But I've already changed the color.

ah... I was thinking you wanted to dynamically change the color. Hadn't even
realized you could permanently change the color, though I certainly should
have!

John W. Vinson [MVP]