470,810 Members | 1,407 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

Control names too long for "Tab Order" window

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

Jun 20 '07 #1
5 2093
On Jun 20, 5:35 pm, Tom_F <fret...@aol.comwrote:
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

Jun 20 '07 #2
On Jun 20, 7:21 pm, CDMAPos...@FortuneJames.com wrote:
On Jun 20, 5:35 pm, Tom_F <fret...@aol.comwrote:
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
CDMAPos...@FortuneJames.com
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
Jun 21 '07 #3
On Jun 20, 7:21 pm, CDMAPos...@FortuneJames.com wrote:
On Jun 20, 5:35 pm, Tom_F <fret...@aol.comwrote:
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
CDMAPos...@FortuneJames.com
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.

Jun 21 '07 #4
On Jun 20, 8:24 pm, Tom_F <fret...@aol.comwrote:
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

Jun 21 '07 #5
On Jun 21, 11:30 am, DavidB <j...@yahoo.comwrote:
On Jun 20, 7:21 pm, CDMAPos...@FortuneJames.com wrote:
On Jun 20, 5:35 pm, Tom_F <fret...@aol.comwrote:
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
CDMAPos...@FortuneJames.com

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

Jun 22 '07 #6

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Prabhudhas Peter | last post: by
4 posts views Thread by R Reyes | last post: by
4 posts views Thread by Bugs | last post: by
1 post views Thread by Rob | last post: by
reply views Thread by mihailmihai484 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.