incorrect tab order

[Janis in Minnesota]

I have a really weird problem.

I have a form that has a tab control with 6 pages. On one of the pages in
the tab control, when I try to change the tab stop index property on the
fields in this page, it changes it to a different number. I cannot get the
tab order correct on this form. Any ideas why this would be happening? All
other forms and pages work correctly except for this one page.

Thanks for any advice!!!!

Janis in Minne-SNOW-ta (and oooh so ready for spring!!!)

 

[Klatuu]

Make sure the Tab Stop property is not set to No.

My understanding is that Minnesota has two seasons:
Winter and Road Repair

 

[phillip9]

Hello,

I am having the same problem, where I enter a different tab index manually
and access immediately changes the tab index to something different as soon
as my cursor leaves the tab index field.

I have the tab stop set to YES on these fields. I have also turned the tab
stop to NO on all fields that should not be tab stops, but the problem
continues.

thanks for your help,

phil

 

[Klatuu]

Where are you setting the tab index?
If you are setting it at the form level, I don't know how that could happen.
If you are setting each control's tab properties separately, you need to set
each tab index starting with the last one and working backwards.
The eaisest place is to set them at the form level.

 

[phillip9]

Hi Klatuu,

Thanks for your help, that's a great idea. I just tried working backwards
and that did not work. Perhaps because I have so many controls. Here are
the two situations.

This is a main form, with 2 subforms and a tab control. The tab control has
9 pages. the first 6 pages are all the controls I need to set tab stops for.
the other pages are subforms. I'm sorry I did not mention this information
before.

if I go to the 6th page and start numbering tab stops backwards, 135 is the
last control; Access says "... valid index is between 0 - 45".

My second shot was to try just working backwords on each page, I went to
page 1 and started with the last control (#24) for page-1, but Access
automatically renumbers the tab stop as it did originally.

I have been manually setting each controls property tab stop field. How
would I set the tab stop at the form level?



barada nikto,

Phill

 

[Klatuu]

Open the form in design view. right click. one of the options is tab order.
You can select a control and move it up or down in the list.