I would like to interrogate the value of a grand totals field to determine
it's formatting

What is the property or object that I must use to get the value and not the
name of the field?

The following returns the name of the field (The same as the name in
parenthesis)

MsgBox PvTbl.PivotFields("Sum of Num of Occ").Value

Thanks for your help!