Automatic tabbing between form fields

Question

I am working on a form that I want the user to enter a multi-digit number in a series of form fields with one number per field. For instance the number would be 12345, but each number is entered into its own field. Instead of the user having to tab to a new field after entering, I want the form to automatically jump to the next field. I know I can set the maximum length for the field to one, but don't know if it is possible for it to jump to the next field.

The reason for doing it this way is that there will be some users completing the form manually, so each field is underlined with a space between to provide a mask to show how many digits are required.

I am working in Office 2003, but my end users are a mix of Office 2003 and 2007.

Thanks for any help you can give.

Answer 1

After reading the two responses received so far, they really do not address my question since I am working in Office 2003, but it did set me to looking at Active X controls instead of the legacy controls. It will take a little bit to get teh formatting the way I want it, but I think I will be able to get it working. Thanks for the prompting.

Answer 2

Set Max length to 1 and set AutoTab property to True..That will autotab as per the tab order specified

Answer 3

Hi,

go to the developer tab, open your form, properties,Alphabetic, Tabindex, enter the order you want to jump, for example your first box will be number 1 the next one will be 2