Back Color

[Clint Liezert]

I am using Windows XP and MSAccess 2002

I would like to be able to change the "back color" of a
subform using Visual Basic. The help information
indicates that it can be done but I can't figure out how
to reference the form "details" section.

 

[Chris]

Where are you trying to change the BackColor?

From the subform itself:
Me.BackColor = vbRed

From the Parent form:

Me.Controls("ControlName of
Subform").Form.Details.BackColor

From any other form:

Forms("Parent Form Name").Controls("ControlName of
Subform").Form.Details.BackColor


Chris

 

[Tim Ferguson]

I would like to be able to change the "back color" of a
subform using Visual Basic.

Like any other property on a subform

Me!ctlMySubForm.Form.BackColor = RGB(1,2,3)


HTH


Tim F