The FormatString property of the Measure interface contains the format used to display the measure values. Any format string valid for use with Microsoft® Visual Basic® is acceptable.
String
Access depends on the value of the ClassType property of the object.
| Class type | Access |
|---|---|
| clsAggregationMeasure | R |
| clsCubeMeasure | R/W* |
| clsPartitionMeasure | R |
* Read-only for virtual cube measures.
Use the following code to set the format string for the measure object [Sales_Facts].[Price]:
'Assume an object (dsoCubeMea) of ClassType clsCubeMeasure exists
dsoCubeMea.FormatString = "#,###.##"