Auto Tab

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Art (anonymous_at_discussions.microsoft.com)
Date: 03/26/04 

Date: Fri, 26 Mar 2004 10:14:13 -0800

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

>-----Original Message-----
>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?
>

Relevant Pages

  • Re: Getting populated fields to automatically skip to the next field
    ... Access provides for this under certan conditions. ... The field in question has to have an input mask that requires a certain ... number of characters ... In Properties - Other the AutoTab Property is set to Yes ...
    (microsoft.public.access.forms)
  • Access 97 Input Mask as Password wont select all the characters
    ... I have an Access 97 form with a text box bound to a field in a table, I have set the Input Mask to Password. ... When I select the box by clicking on it or dragging the mouse over it, all the characters are selected except the last one on the right hand side. ... It seems the only way to select all the characters is to Tab to it. ... Does anyone have a fix for this? ...
    (comp.databases.ms-access)
  • Re: I have attached a module that accomplishes what I want and does it veryquickly.
    ... I need to know whether the string in the first 'column' is going to extend past the next tab. ... settings and background colors, so the end result looks like a table, ... width of the current tab space it needs to fit into, ... If you know how many characters fit in a specified area that you are ...
    (microsoft.public.word.vba.general)
  • Re: Great SWT Program
    ... Vim -- car is fixed, ... and/or press tab again to get a list of choices. ... to type one or more additional characters and press tab again. ...
    (comp.lang.java.programmer)
  • Re: Decatenate a field with Make Table Query?
    ... You can probably do something similar in MS Word, lining them up using tab characters in ordinary paragraphs. ... You can use Word to delete lines that contain only white space, and you can delete repeated paragraph marks. ... I would define a special paragraph style that would include the tab settings for this operation, but would not save it in the global Word template, as you'll likely never need this style again, so leave "Add to Template" unchecked, but check "Automatically Update". ... In the Excel cell the paragraph marks show up as bangs; ...
    (microsoft.public.access.queries)