According the documenation for Access 2002 (I could find no documentation
for 2007 either in Help or on the Microsoft web site):
http://msdn.microsoft.com/en-us/library/aa139960(office.10).aspx
The code to use is:
Dim pTable as OWC10.PivotTable
Set pTable = Forms("FormName").PivotTable
pTable.BackColor = 255
In Access 2007, changing the lines to
Dim pTable as OWC11.PivotTable
Set pTable = Me.PivotTable
Does not work - I get a type mismatch error. If I place a pivot grid ActiveX
control on the form I get no problems .
Is this a bug in Access 2007 that you cannot use the properties of the
Access Form PivotTable?
Regards
Justin