Changinf the Data Format of Fields in a Datagrid
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