can anyone help me please.

i have a datagrid attached to an adodb datasource. One of the columns in my datagrid is a currency field.

I am trying to format that column in the datagrid to display the currency

I have the WROX Book Professional VB6 Databases, by Charles Williams, on page 299 he shows an example of how to do this, however, i cant get it to work, i keep getting a error 438 object doesnt support this property or method

this is the code that i am using on the load event of my form

Dim fmtcurr As New StdDataFormat
fmtcurr.Format = "Currency"
Set Me.Adodc1.Recordset = GetRecordset("Select * from PROJECTFUNDINGPACKAGE where ProjectiD = 10001")
Me.DataGrid1.Columns(3).DataFormat = fmtcurr

The data format should be a standard format.. I don't know what is StdDataFormat, maybe is a custom class, but the grid only accepts standard formats (in facts, the format is a string with the name) Maybe you missed something about this examples??

__________________
HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question.
(Took that from Doug signature and he Took that from Peter profile)
================================================== =========
My programs achieved a new certification :
WORKS ON MY MACHINE
================================================== =========
I know that CVS was evil, and now i got the proof.
================================================== =========