Control names too long for "Tab Order" window

[Tom_F]

To comp.databases.ms-access --

I am trying to re-number the "tab index" for a large number of
controls on a form. When I try to do this one control at a time,
Access automatically re-numbers the tab index for some of the other
controls, thereby messing up what I'm trying to do. I know about the
"View--Tab Order" option, but the trouble with this is that it doesn't
show entire field names ... and my field names are rather long.
Therefore, I can't always tell which field is which!

Any ideas on how to proceed would be very welcome. I'm using Access
2003. Thanks, Best,

--Tom

[CDMAPoster]

On Jun 20, 5:35 pm, Tom_F <[e-mail]:

To comp.databases.ms-access --

I am trying to re-number the "tab index" for a large number of
controls on a form. When I try to do this one control at a time,
Access automatically re-numbers the tab index for some of the other
controls, thereby messing up what I'm trying to do. I know about the
"View--Tab Order" option, but the trouble with this is that it doesn't
show entire field names ... and my field names are rather long.
Therefore, I can't always tell which field is which!

Any ideas on how to proceed would be very welcome. I'm using Access
2003. Thanks, Best,

--Tom

From:

http://groups.google.com/group/comp....0a3bfba9c2f50c

Dragging all the controls off the Detail section and dragging them
back in the desired order worked well for me.

James A. Fortune
CD********@FortuneJames.com

[Tom_F]

On Jun 20, 7:21 pm, [e-mail] wrote:

On Jun 20, 5:35 pm, Tom_F <[e-mail]:

To comp.databases.ms-access --

I am trying to re-number the "tab index" for a large number of
controls on a form. When I try to do this one control at a time,
Access automatically re-numbers the tab index for some of the other
controls, thereby messing up what I'm trying to do. I know about the
"View--Tab Order" option, but the trouble with this is that it doesn't
show entire field names ... and my field names are rather long.
Therefore, I can't always tell which field is which!

Any ideas on how to proceed would be very welcome. I'm using Access
2003. Thanks, Best,

--Tom

From:

http://groups.google.com/group/comp..../browse_frm/th...

Dragging all the controls off the Detail section and dragging them
back in the desired order worked well for me.

James A. Fortune
[e-mail]

Mr. Fortune --

Thanks for the idea! I guess I'll try that if I have to ... but the
thought of having to re-do all that painstaking arrangement of
controls is a bit daunting. Does anyone out there have any other
approaches I might try? Thanks!

--Tom

[DavidB]

On Jun 20, 7:21 pm, [e-mail] wrote:

On Jun 20, 5:35 pm, Tom_F <[e-mail]:

To comp.databases.ms-access --

I am trying to re-number the "tab index" for a large number of
controls on a form. When I try to do this one control at a time,
Access automatically re-numbers the tab index for some of the other
controls, thereby messing up what I'm trying to do. I know about the
"View--Tab Order" option, but the trouble with this is that it doesn't
show entire field names ... and my field names are rather long.
Therefore, I can't always tell which field is which!

Any ideas on how to proceed would be very welcome. I'm using Access
2003. Thanks, Best,

--Tom

From:

http://groups.google.com/group/comp..../browse_frm/th...

Dragging all the controls off the Detail section and dragging them
back in the desired order worked well for me.

James A. Fortune
[e-mail]

In the manual renumber mode the way I have found to get around the
issue you describe is to number the tab order starting with the last
item and working back to the first.

[CDMAPoster]

On Jun 20, 8:24 pm, Tom_F <[e-mail]:

Mr. Fortune --

Thanks for the idea! I guess I'll try that if I have to ... but the
thought of having to re-do all that painstaking arrangement of
controls is a bit daunting. Does anyone out there have any other
approaches I might try? Thanks!

--Tom

I'll see if I can try out Smartin's idea this weekend. The alignment
tools worked well for my arrangement so it took little time to get
them back. Consequently, I didn't have to resort to anything else.
Smartin's idea seems the better way to go. My subconscious is already
starting to generate ideas. One time I awoke from a night of sleep
with the solution to a difficult mathematical proof. Alas, my
customers don't pay me for the time I spend solving problems while
sleeping unless I'm working on a contract basis :-).

James A. Fortune
CD********@FortuneJames.com

[Tom_F]

On Jun 21, 11:30 am, DavidB <[e-mail]:

On Jun 20, 7:21 pm, [e-mail] wrote:

On Jun 20, 5:35 pm, Tom_F <[e-mail]:

To comp.databases.ms-access --

I am trying to re-number the "tab index" for a large number of
controls on a form. When I try to do this one control at a time,
Access automatically re-numbers the tab index for some of the other
controls, thereby messing up what I'm trying to do. I know about the
"View--Tab Order" option, but the trouble with this is that it doesn't
show entire field names ... and my field names are rather long.
Therefore, I can't always tell which field is which!

Any ideas on how to proceed would be very welcome. I'm using Access
2003. Thanks, Best,

--Tom

From:

http://groups.google.com/group/comp..../browse_frm/th...

Dragging all the controls off the Detail section and dragging them
back in the desired order worked well for me.

James A. Fortune
[e-mail]

In the manual renumber mode the way I have found to get around the
issue you describe is to number the tab order starting with the last
item and working back to the first.

Thanks! I tried this "last to first" method. It worked some of the
time, but not all of the time (sometimes the tab order got
scrambled). Perhaps my situation is complicated by the fact that my
controls are located on a page of a "tab control"? In any event, I
FOUND A SOLUTION which seems to work for me. First, I temporarily re-
name the controls so that they start with "01", "02", etc. Then, when
I use "View--Tab Order", I can determine the order that I want, no
matter how long the field names are. Once the desired tab order is
set, I simply re-name the controls back to their original names. As I
said, this seems to work for me (fingers crossed). Thanks again to
you, and to all the others, for helping me with this problem! Best,

--Tom