Arrange fields on a form

[Alaska1]

I am working in a form in access. I have added more fields to the form.
Everytime I edit a field I have to reinsert the field on the form. When I
reinsert the field it no longer will keep the order I arranged. I want to be
able to tab to my fields when entering data, but If I have to reinsert the
field again it tabs to that field last. How do I rearrange that field where
I want it without adding all the fields again?

 

[Arvin Meyer [MVP]]

Depending upon your version, in the form's design view:

View >>> Tab Order

and change it. Alternatively, you can use the tab index property displayed
on the property sheet so change the tab order.

 

[John Spencer]

THere is a tab order property.

You can easily change the tab order by selecting View: Tab Order from the menu
(in Access 2003 and earlier). And then dragging items up and down the list to
rearrange the order.

Also look at the Tab Index property of the controls. You can change that to
change the order value to change the order also.

John Spencer
Access MVP 2002-2005, 2007-2010
The Hilltop Institute
University of Maryland Baltimore County

 

[Maurice]

My assumption is that you mean the taborder of the fields here right? Take a
look at the properties of the form and choose taborder there. You will see a
list with al the fields you've placed on the form and that's where you can
rearrange the order of how the tab key will work on your form.

In designview of the for rightclick on the upperleftcorner of the form (the
grey square) and choose taborder.

Another option is to set the tabindex of the objects you are placing on the
form. In that case adjust the numbering of the index to the order you'd
prefer.

hth