>Thanks for your response. That was helpful.
>
>>With ADO, you don't need to!
>>Set datagrid1.DataSource = rstData
>
>Does this allow you to choose columns and set column properties in the property sheet of the grid?
You have to do it programmatically:
with datagrid1
with .columns(0)
.datafield = "DataFieldName1"
.locked = true
end with
with .columns(1)
.datafield = "DataFieldName2"
.width = 2000
end with
with .columns(2)
.datafield = "DataFieldName3"
.visible = false
end with
end with
Éric Moreau, MCPD, Visual Developer - Visual Basic MVP
Conseiller Principal / Senior Consultant
Moer inc.
http://www.emoreau.com