Tab Index of fields NOT reacting in Order

[Alan K]

Afternoon All,

Thanks to everyone that assisted in my last issue - Now resolved.

Scenario: Have an Access form - Five (5) fields involved in my question: Field 1 is "Enabled" - On. Fields 2 - 5 start out as "Enabled - Off".
Field 1 is a Date field - So, I enter 01/11/2025. Field 2 Becomes "Enabled". You enter valid data for Field 2 - Field 3 Becomes "Enabled".

Data gets entered into Field 3 - Here's where the problem is: The cursor AFTER entering data in Field 3 moves to Field 6.

I checked the Tab Index of ALL my fields, and they are in sequence How I need them.

Field 1 - Tab Index 5
Field 2 - Tab Index 6
Field 3 - Tab Index 7
Field 4 - Tab Index 8
Field 5 - Tab Index 9
Field 6 - Tab Index 10

Any ideas what could be causing the out-of-sequence issue?

Thanks

Alan

 

[The_Doc_Man]

Tab indexes can be cyclic. If you tab out of the control AND the controls with higher indexes are not enabled AND your form is set appropriately, you go to the next enabled field earlier in the list. Verify which controls are enabled at the time.

To look at your tab behavior, on Access opened to a database, click File >> Current Database >> Client Options and the first set of options you get is the behavior when tabbing through fields. Somewhere in there you will find the behavior you want, perhaps. HINT: It means that in the Editing options, you do not have "Next Record" selected. If you have "Next Field" selected then that might be PART of why you get this behavior. But let me ask this: Do you set "Tab Stops=Yes" (or ="No") for those items? Because enabling the field isn't the only part. You can have an enabled field that is nonetheless not part of the normal visitation sequence if its TabStop setting is "No" but its Enabled setting is "Yes."

 

[Alan K]

Have the Tab Stops = Yes
Have the Tab Index in sequence.

That's what's throwing me off. I thought those 2 setting where the only 1's dictating movement order.

Also, this is ONLY Tab Order issue on a Form - NOT issue cycling through records.

 

[Gasman]

So I am going to guess that CONTROLS! 4 & 5 are disabled/locked?

 

[DHookom]

I would suggest you provide a screen shot of the tabs like the following (not my app)

 

[The_Doc_Man]

Also, this is ONLY Tab Order issue on a Form - NOT issue cycling through records.

The setting I indicated includes how you cycle through controls as well as records. It governs the behavior of the form when you hit the enter key, which is one way to cycle through controls.