dbgrid data entry validation

[Beacon]

Hey all,

How can i make sure that what the user enters is correct!

For example:

I have in the grid on it's button click event it shows a combo box. I want to make sure that if they manually enter data into that column that it's correct or stop them from manually entering data without selecting it from the combo box.

if that doesnt make sense please tell me?
thanks

[rudvs2]

Beacon mate

Im not sure if I have understood your question correctly

But If you were wanting to validate the text before it is written to the database
Use the Before Update and After Update events in the datagrid

Then you can have a routine in ther which checks the string for a set of your specified parameters

Let me know if im way off

[Beacon]

yep figured it out did it this way:

Private Sub dbgrid_ColEdit(ByVal ColIndex As Integer)
If ColIndex = 0 Then
MsgBox "Please Select Item From List", vbExclamation, "InValid Entry"
ElseIf ColIndex = 2 Then
MsgBox "Please Select Item From List", vbExclamation, "InValid Entry"
ElseIf ColIndex = 3 Then
MsgBox "Please Select Item From List", vbExclamation, "InValid Entry"
End If
End Sub

So they cant type in values which is heaps better!
thanks anyways rudvs2