Hi,

I am running a access 97 database to create a pivot form based on a table. What I would like to do is format the headings of the Pivot Form and apply some bolding to the text etc. Is this at all possible from VBA??? I think I would need to copy the form into a new sheet but dont now how!!!

Many thanks

Tim

Tim

__________________
Tim

Is this an Excel Question? It sounds like you ought to post this in the access vba forum.

Cheers

Matthew

You can modify various parts of the pivot by selecting the part you want to format and then changing the settings for the portion selected.

Search VB Help for pivotselect

Some sample code:

    ActiveSheet.PivotTables("PivotTable1").PivotSelect "NAME[All]", _
        xlLabelOnly
    With Selection.Font
        .Name = "Arial"
        .FontStyle = "Bold"
        .Size = 10
        .Strikethrough = False
        .Superscript = False
        .Subscript = False
        .OutlineFont = False
        .Shadow = False
        .Underline = xlUnderlineStyleNone
        .ColorIndex = xlAutomatic
    End With

This code would bold the labels for the pivot object NAME

For an easy way to determine the required code, record a macro, do what you want
done, and then look at the macro to see what the code looks like.