Subform box color

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When you create a subform space on a form, the area that is not filled with
data is gray. Is there a way to change that color or make it transparent?

Thanks
Steve
 
If you created the subform as a separate form, then added it to the main
form, you can change the back color of the subform's detail, header, and
footer sections. If you used autoform, or if you are trying to format the
subform control (as opposed to the subform object) I don't think you have any
real options in that regard.
 
I did not use the autoform option. The subform is being displayed on the
form in datasheet mode ... so whatever is NOT a row of data inside the
subform box created on the form is gray. I don't want any gray in the
subform box. If I can't change the color, can the box auto size to the data
that's present? Or do you have another suggestion as to how to show a
datasheet of values on a form that doesn't have the gray box?

Thanks
Steve
 
suggest you try changing from Datasheet view to Continuous Forms view. you
can format the form in design view to look very much like a datasheet, *but*
you can also hide the RecordSelectors, the DividingLines, make the controls
transparent to show the background color of the subform object, etc - in
short, you have much more control of how the subform looks when in form
view. the only things that will still be gray are the NavigationBar and the
ScrollBar(s) - and you can simply hide those if you don't need them.

if your data will be viewed but not edited, another option is to use a
Listbox control. you can't make the control's Background transparent, but
you *can* set it to the same color as the subform's background, and you can
make the control's BorderStyle transparent. these two setting will
effectively make the data list seem to sit directly on the subform, with the
only "gray" elements being the vertical/horizontal scroll bars which will
automatically appear or not according to the contents of the list box.

hth
 
Back
Top