Tab Stops that Go!?

[David.Krebsbach]

Those pesky little Tab Stops don't always work, do they!? I set the tab
stops to Yes/No accordingly, but the No's still require a Tab Index and the
stops are ignored (Access 2007).

What to do???

 

[Dirk Goldgar]

Those pesky little Tab Stops don't always work, do they!? I set the tab
stops to Yes/No accordingly, but the No's still require a Tab Index and
the
stops are ignored (Access 2007).

I've never known tab stops not to work as expected. What exactly are you
seeing? All controls that can receive the focus have a tab index, but only
those with Tab Stop = Yes can be tabbed to. Note that you need more than
just the Tab key to move between form sections, or from a subform back to
its parent form.

 

[David.Krebsbach]

All the controls have a Tab Index and Tab Stop property. I only want certain
Tab Stop = Yes, other Tab Stop = No. Regardless which setting, they all
insist on a Tab Index value (integer) - even if Tab Stop = No. Back in Form
view, the focus is set to the control with Tab Index = 0, and the tabs flow
as intended until the last control with Tab Stop = Yes, then the tab (focus)
disappears for several tabs (4-6 times) until finally returning to the
control with Tab Index = 0.

Where is the focus going during those extra tab keys? How do I get the
focus back to the Tab Index = 0 after finishing with Tab Index = 6 (my last
desired tab stop)?

I'm sure it can be done with VB, but I would think the Tab Index / Tab Stop
behaviors would be more straight forward than I'm experiencing - but then,
there is that little "MS" in front of Access 2007, isn't there!? ;-)

Looking forward to the words of wisdom which "auto-magically" come from this
forum!

 

[Dirk Goldgar]

All the controls have a Tab Index and Tab Stop property. I only want
certain
Tab Stop = Yes, other Tab Stop = No. Regardless which setting, they all
insist on a Tab Index value (integer) - even if Tab Stop = No.

Yes, that's the way it's supposed to be. That way, you can manipulate the
TabStop property if you want, without having to renumber all the indexes.

Back in Form
view, the focus is set to the control with Tab Index = 0, and the tabs
flow
as intended until the last control with Tab Stop = Yes, then the tab
(focus)
disappears for several tabs (4-6 times) until finally returning to the
control with Tab Index = 0.

Where is the focus going during those extra tab keys? How do I get the
focus back to the Tab Index = 0 after finishing with Tab Index = 6 (my
last
desired tab stop)?

I'm not sure what's going on, but I would guess that you have some controls
that have their TabStop property set to yes, but you can't easily tell that
the controls have the focus. Maybe they are controls with Width and/or
Height set to 0 -- I do that sometimes, when I need a visible control on the
form that can receive the focus, but I don't want the user to interact with
it.

If you want to know where the focus is at some point when it seems to have
disappeared, press Ctrl+G to bring up the Immediate Window, and enter the
statement

?Screen.ActiveControl.Name

After you press enter, the name of the active control should be displayed on
the next line.

I'm sure it can be done with VB, but I would think the Tab Index / Tab
Stop
behaviors would be more straight forward than I'm experiencing - but then,
there is that little "MS" in front of Access 2007, isn't there!? ;-)

I have never found these properties to behave other than as I expect, so
before concluding that they don't, let's look deeper into what's going on.
Of course, Access 2007 *is* a thorough makeover of the program, and
certainly still has some bugs. But you're the first person I've heard from
so far suggesting that the tabbing functionality was among them.

Looking forward to the words of wisdom which "auto-magically" come from
this
forum!

Tsk. You're doomed. <g>

 

[Tony Toews [MVP]]

?Screen.ActiveControl.Name

Very nice. Blogged
http://msmvps.com/blogs/access/archive/2009/04/10/which-control-has-the-focus.aspx

Tony
--
Tony Toews, Microsoft Access MVP
Please respond only in the newsgroups so that others can
read the entire thread of messages.
Microsoft Access Links, Hints, Tips & Accounting Systems at
http://www.granite.ab.ca/accsmstr.htm
Tony's Microsoft Access Blog - http://msmvps.com/blogs/access/

 

[Cindy]

I'm working with Access 2002 (on a PC that has Access 2003 also
installed), and just ran into a form that keeps changing the tab stops
on me. The fields are on a tab control on a form - there are about 20
fields on this one tab control page I set the tab stops, saved the
form, and when it was re-opened, the tab stops were helter skelter.
The only fix I came up with was to remove all controls from the tab
and place them back on, one at a time, in the order I needed them. (I
tried resetting them manually, both using the index property and the
tab control pop up - at least 4 times, thinking I was going
crazy....!!!)

I have never experienced this problem before - this is a first (and I
do a lot of Access work). I came across this post in searching for a
solution! I'm up to date with patches. Access 2007 WAS installed at
one time on this PC - later removed, with a total re-install of all
office products after the removal of Access 2007. Makes one go
hmmm!!! I'm just crossing my fingers now that the "fix" will stick!

In this example, for what it's worth, I have 7 pages on the tab
control. Six pages work fine. It's only the one that 'went to
lunch'.