data grid

[ishikha]

hi friends,

i am having one problem.i am using datagrid control.now i want that when i add new row in it i leave it blank .i mean to say that if i am having three columns in data grid i want to leave it blank all the three columns and then want to add new row.but it not adding the new row until i write something in one of the three columns.

can u tell me how i am able to do it


regards
ishikha

[ishikha]

the code i am using is::
Private Sub add_Click()
DataGrid1.AllowAddNew = True
DataGrid1.AllowUpdate = True
On Error GoTo 11
If adors.BOF Then
DataGrid1.SetFocus
SendKeys "{home}+{down}"
Exit Sub
Else
adors.MoveLast
DataGrid1.SetFocus
SendKeys "{down}"
Exit Sub
11:
MsgBox Err.Description
End If
End Sub

ishikha

[khalik]

if i got it right

u have a datagrid and u want to 2 new rows... i.e. 2 empty rows i dont think that possible it can have one one new row.


the recordset object can accept only one addnew method so it not possible..
u can do it by using flexgrid...

[ishikha]

no i don't want to add two new rows .

i only want that if i want to leave the whole row blank then i am able to do so.
the problem i am facing is that when i leave the whole row blank i can't able to add new row

ishikha

[khalik]

Originally posted by ishikha
no i don't want to add two new rows .

i only want that if i want to leave the whole row blank then i am able to do so.
the problem i am facing is that when i leave the whole row blank i can't able to add new row

ishikha

hi ishikha
when u get a blank row in datagrid the recordset calls a addnew method...
when u leave entire row blank and u want to get one more it not possible...

i hope i made it clear....

[ishikha]

there is no other way by which i am able to leave the whole row blank in datagrid

[khalik]

Originally posted by ishikha
there is no other way by which i am able to leave the whole row blank in datagrid

using datagrid i dont think it possible