OWC 11 Changing BackColor and ForeColor, etc for Row/Column Items

C

CodeGeek

I'm having a heck of a time figuring out how you are supposed to change the
backcolor, forecolor, etc for the items in the row and column drop areas...It
seems that they should be properties of a pivotlabel object that gets
returned, but I can't seem to figure it out...

Any help would be greatly appreciated!
 
C

CodeGeek

Solved my own problem...

In simplistic form:

For Each fset in ptable.ActiveView.RowAxis.FieldSets
For Each fld in fset.Fields
fld.GroupedBackColor = <insert color here>
fld.SubtotalLabelBackColor = <insert color here>
Next
Next

Repeat the same process for the column axis...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Office Web Components (OWC) 11 and 64-bit OS 2
BackColor, Forecolor, Bold, and Font Size for ComboBox in Commandbar 8
Row, Column, and Filter areas not shown Access 2002 0
Items in consecutive Selection collections not the same? 3
FP2002 and VB and OWC 0
Accessing Outlook 2003 Email Items 1
Iterate through query results and perform operations? 0
Iterate through query result and perform operations? 0

Top