Data grid caption

[Mukesh2375]

i made a data grid using a recordset.
i changed header for each column using dGrid.Columns(0).Caption = "Caption 1"
after some data updations, i refresh the recordset using
rs.Resync adAffectCurrent, adResyncAllValues
problem is the headers for DataGrid get reinitialised with field names of the recordset or with values like Expr1001. Also width of columns change. can anybody suggest me a remedy?

 

[CCLINT]

DataGrid1.HoldFields
rs.Resync
DataGrid1.Rebind [/b][/i][/u][sub]*******************************************************
General remarks:
If this post contains any suggestions for the use or distribution of code, components or files of any sort, it is still your responsibility to assure that you have the proper license and distribution rights to do so!