After execution the DataGrid1.Columns(0).Caption property is set to Field.Name

klen_ · September 14th, 2009, 09:54 AM

Hello!
What is wrong this property?
I use Adodc1 and DataGrid1.
I try to do this by code.

Code:

Set DataGrid1.DataSource = Me.Adodc1
    
Me.DataGrid1.Columns(0).Caption = "Phone"
Me.DataGrid1.Columns(0).NumberFormat = "000 00 00"
Me.DataGrid1.Columns(0).DataField = "fld1"

But it is not working. Instead the caption property is set âfld1â.
The property NumberFormat is not shown correctly too.
Please help me.

debbiecoates · December 9th, 2009, 06:37 AM

I do a similar thing, but set it like this, it works fine, hope this helps

Code:

sub sSetGrid()
fmtNumber.Format = "#,##0; (#,##0)"With Me.DataGrid_SpendProfile
   .Columns(0).Visible = False     
   .Columns(1).Visible = False     
   .Columns(2).Visible = True      
   .Columns(2).Locked = True
   .Columns(3).Visible = True      
   .Columns(3).width = 1000
   .Columns(3).Alignment = dbgRight
   Set .Columns(3).DataFormat = fmtNumber
End Withend sub
 
so in your case you would need to use something like this
 fmtNumber.Format = "## ## ####"
 Set .Columns(3).DataFormat = fmtNumber