length of text on datagrid

[Casiopea]

I don't know how to control the length of the text inside a column. I want to know the length of the text inserted/updated on the cell before updating. If the text is greater than 20 characters I want to warn the user. Right now instead of that, the application send an error (because sometimes the length is greater than the length of the column defined on the field of the table) and don't let me update it or cancel the update event.

The datagrid has allowNew, alloUpdate set to true.

 

[selimsl]

Hi!

Private Sub Text1_Change()
If Len(Text1.Text) > 5 Then
Text1.SelStart = 5
Text1.SelLength = 1
Text1.SelText = ""
MsgBox "dsf"
End If
End Sub

I hope this helps you...

 

[Casiopea]

Thank you for that answer, but the problem is the datagrid cell length. That cell shows the content of a field in a recordset. If the user wants to change it, I want to control that the length is not greater than the field size.