AutoTab or auto changing focus?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a data entry form where the user enters several feilds that are made
up of 2 numerals and it uses an input mask. Is there anyway to change the
focus to the next feild when the input mask is satisfied with out having to
press enter or tab?
 
Todd,

You could use the "OnChange" event of the textbox. This event fires
whenever a character is added or deleted. So you might use something like:

Private Sub txt_YourTextBox_Change

If LEN(me.txt_YourTextBox.text & "") = 2 then me.txt_NextControl.setfocus

End Sub

Note that you have to use the text property of the control instead of its
value.

HTH
Dale
 
I have a data entry form where the user enters several
feilds that are made
up of 2 numerals and it uses an input mask. Is there anyway to change the
focus to the next feild when the input mask is satisfied with out having to
press enter or tab?
Click to expand...

I think setting the "auto-tab" property in the property
sheet to "yes" will do this.

Jesper
 
Back
Top