Cannot set anything in DataGrid?

[welldefined]

Very strange!!
I used DataGrid to display .mdb by connection and recordset by ADO. It works fine. I then set the layout propty and run again, but nothing can by displaied this time! I change back the setting, no good. Why?

 

[RonRepp]

WellDefined:

Show the code and someone will probably be able to help.



Ron Repp

If gray hair is a sign of wisdom, then I'm a genius.

 

[welldefined]

Perhaps I didn't expain clearly, let me try again:

I used VB+DataGrid to display .mdb, It works fine. Then, in design mode, I set the layout Alignment propty from 1 to 2 and run again, but nothing can be displaed this time! I change back the setting to 1, still no good.

Following is my code, I don't think anything to do with this, but:

Dim oConnection As New adodb.Connection, oRecordset As New adodb.Recordset
Dim dFile As String

dFile = App.Path & "/dFile.mdb"
oConnection.Open "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & dFile
oRecordset.CursorLocation = adUseClient
oRecordset.Open "Select * from table1", oConnection, 3
Set DataGrid1.DataSource = oRecordset