Does anyone know how you would go about formatting a column of data in a bound MSHflexGrid to display a $000.00 format?

I have a bound MSHFlexGrid to an ado object, with an Access 97 database on the back end. I am displaying one column in the FlexGrid which contains a "monetary" value. I've tried using a text datatype for this field in Access, and defining an input mask property to store the values for this field in a $000.00 format. I've also tried changing the data type in Access to Currency, although I would prefer to store the value as text only. Neither of these approaches work, the column of data is displayed in the MSHFlexGrid as just a line of numbers (23455) with no decimal point and no preceeding $.

Any advice or ideas would be greatly appreciated!!!!

chaseltine