Turn Thousands Separators On via VBA for a specified field

Discussion created by t0rnado on Mar 16, 2011
Hello Everyone,

I have created a VBA routine that generates a DBF table. I am using the ArcGIS Desktop 10 Reports function to generate a report based on a specified field.

I am unable to find a way to format the Double field to use commas for thousands separators in the Reports itself. However, I have found that if you open the table > RC the Field > Properties > Numeric Format (Ellipsis) and check on Thousands Separators, the Report will use them.

Does anyone know a way to either format the number in the report, or format the field to use thousands separators via VBA?