Trigger from input in a textbox without clicking enter

[item67]

Hello, I have a question. A have a form whit a textbox (for 1 charater). When I enter a character in the textbox en click on enter it activates some changes on the form (afterupdate event). This works fine but I want to activate the change without clicking on enter. Ergo if I enter the value the change should take place. Is this possible?

[Bob Fitz]

Have you tried using the On Change event instead of the After Update event.

[item67]

Yes I tried that but it did not give the response I want.

[Bob Fitz]

So what response did it give and how was it different from what you wanted

[item67]

Well when I use this event I have to enter the character, click enter and enter the character again to activate.

[orange]

Please show us the code in your AfterUpdate event.

[Missinglinq]

1. In the Table make the length of the underlying Field to 1
2. In the Form set it's Input Mask to L
3. In Properties - Other set the AutoTab Property to Yes

Or, where X is the maximum length of the data in YourTextBoxName and NameOfNextControl is the next control to gain focus.

Private Sub YourTextBoxName_Change()
  If Len(Me.YourTextBoxName.Text) = X Then 
    NameOfNextControl.SetFocus
  End If
End Sub

Linq ;0)>

[PC-Gram]

This works:

Private Sub No1_KeyUp(KeyCode As Integer, Shift As Integer)
Me.No2.SetFocus
End Sub