go to next field

[tweety]

hi



if i want go to next field after i changed the value how and where do i set it?

its easier for the end and saves them from clicking and pressing the tab key

thanks in advance

[June7]

Must press tab or enter key to cause movement to next field/control. Or use code in control AfterUpdate event to set focus to another control.

[tweety]

thanks for that

[Missinglinq]

There's two ways to do this, but they both require that the Control being exited always has a predefined number of characters, such as telephone numbers, Social Security numbers, ID Number, etc.

If the Control also has an Input Mask set (which I never do, IMs being more trouble than they're worth, IMHO) you can set its AutoTab Property to 'Yes,' and once the Input Mask has been complied with, the Focus will move to the next Control in the Tab Order.

Without an Input Mask set, you can use some code to advance to another Control, once the required number of characters have been entered:

Replace X with the required length of the data in the OriginalTextBoxName and NameOfNextControl with the name of the next Control to gain Focus.

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

But keep in mind, both of these methods will only work if the number of characters in the original Textbox is always fixed.

Linq ;0)>

[June7]

Ooops, I forgot about AutoTab with InputMask. I have used InputMask with success but never set AutoTab. Users are required to Tab or Enter to commit entry.