Hello again,

Did this approach work for you? If not, please do not hesitate to ask anything related to this topic.

I still didn't resolve this. I will try to see if I can determine if the column type is money by using the DataType property on each column and format accordingly.

Thanks.

Hello,

I am just checking about the progress of this issue. Please let me know If you need my further assistance on this.

Hello bdisk,

I do not see how the grid will sum the varchar field. You would have to make a custom summary by casting the values to double or something like that.

Please do not hesitate to contact us if you need any additional assistance.

Yes, that correct - except its not a money field since theres a dollar sign in front of it, so it's a varchar field now. 

Is there a way to sum varchar fields?

(As I've mentioned, the grid columns are dynamic, and therefore I can't just format and add the dollar sign in code or in a designer property.)