Auto Tab

  • Thread starter Thread starter Kendo
  • Start date Start date
K

Kendo

I've just found the auto tab option in my access forms and
think it may be excellent, but cannot see how to apply it
properly. I want to cause a text field which is set to
accept 255 characters to auto tab into another text field
should a user type past this number of characters. So far
I've tried to create an input mask to trigger this but
with no success. Any ideas out there?
 
Hi Kendo,
From Access HELP:

You can use the AutoTab property to specify whether an
automatic tab occurs when the last character permitted by
a text box control's input mask is entered. An automatic
tab moves the focus to the next control in the form's tab
order.

Setting

The AutoTab property uses the following settings.

Setting Visual Basic Description
Yes True (-1) Generates a tab when the last allowable
character in a text box is entered.
No False (0) (Default) Doesn't generate a tab when the
last allowable character in a text box is entered.


You can set this property by using a form's property
sheet, a macro, or Visual Basic.

You can set the default for this property by using the
control's default control style or the DefaultControl
method in Visual Basic.

The AutoTab property affects tab behavior in both Form
view and Datasheet view.

Remarks

You create an input mask for a control by using the
InputMask property.

You can also create an input mask for a text box control
bound to a field by setting the InputMask property for the
field in the form's underlying table or query. If the
field is dragged to a form from the field list, the
field's input mask is inherited by the text box control.

You could use the AutoTab property if you have a text box
on a form for which you usually enter the maximum number
of characters for each record. After you have entered the
maximum number of characters, focus automatically moves to
the next control in the tab order. For example, you could
use this property for a CategoryType field that must
always be five characters long.

Hope This Helps
 
Back
Top