The FormatContent object formats or converts the values to be displayed on the columns/rows. For instance, you can specify a column to be display its content as currency, or you can show the control's content in uppercase. The Expression property specifies the format to be applied on objects. The FormatContents collection is displayed on the control's context menu under the Content sub menu as shown bellow. Use the Add method to add new FormatContent objects. If the FormatContent's Expression is not valid, the object shows as disabled in the control's context menu. If the PivotBarVisible property includes the exPivotBarAllowFormatContent flag, the control's context menu includes the FormatContent objects. If the exPivotBarAllowFormatContent flag is missing from the PivotBarVisible property, the control's context menu displays no FormatContent objects.  

Here's a few samples on how to use the FormatContent objects:

• FormatContents.Add("upper","upper(value)"),  displays the column/row in upper-case, such as 'ROMANIA' instead 'Romania'

• FormatContents.Add("longdate","longdate(date(value))" ), displays the object's content as date in long format, such as 'Monday, December 31, 2012'

• FormatContents.Add("letter","'<b><fgcolor=808080>' + upper(value left 1) + '</fgcolor></b> ' + value" ), shows the first letter twice in bold and gray, such as 'R Romania' instead 'romania'

• FormatContents.Add("proper","'<b>' + ((0:=proper(value)) left 1) + '</b>' + (=:0 mid 2)"), displays the first letter in bold and upper-case, and let the rest unchanged, such as 'Mihai Filimon' instead 'mihai filimon'.