TabIndex is not working (1 Viewer)

lana

Registered User.
Local time
Today, 10:40
Joined
Feb 10, 2010
Messages
92
Hi there,


I am having a strange problem with TabIndex in one of my subforms.
It does not change. I change the numbers but nothing happens and the columns order does not change. (Access 2003)

Any idea?
Cheers
 

bob fitz

AWF VIP
Local time
Today, 06:10
Joined
May 23, 2011
Messages
4,717
You need to change the Page Index property of each of the pages on the tab
 

lana

Registered User.
Local time
Today, 10:40
Joined
Feb 10, 2010
Messages
92
Thank you.

I don't have Tab control. Just a simple sub-form with 6 columns in datasheet view.
 

isladogs

MVP / VIP
Local time
Today, 06:10
Joined
Jan 14, 2017
Messages
18,186
You can also change the tab order from the design ribbon
This should automatically update the tab index and may be quicker to do

BTW Changing the tab order does not change the order the columns of a datasheet are displayed on your form
To do that, move them manually
 

Minty

AWF VIP
Local time
Today, 06:10
Joined
Jul 26, 2013
Messages
10,355
The column order in datasheet view will be determined by the underlying query - not the tab order from memory.

(Don't use datasheet view very often tbh)
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 02:10
Joined
Feb 19, 2002
Messages
42,981
Access has some warped memory of column order for DataSheet view. When I ran into this problem, the only way I was able to resolve the problem was to rebuild the query (copy the string to notepad. then copy it back and paste it into a new query). But start by opening the form in form view and see if you can manipulate the show/hide columns properties. That might also fix it.
 

isladogs

MVP / VIP
Local time
Today, 06:10
Joined
Jan 14, 2017
Messages
18,186
This method works for me (A2010)
Click & hold the datasheet column header that you want to move.
Wait until a thick blue vertical line appears down the left of the column (about a second). Drag the column to the new position.
NOTE: You can do this with 2 or more adjacent fields together
Save.
Close.
Reopen and the new datasheet column order has stuck!
 

missinglinq

AWF VIP
Local time
Today, 02:10
Joined
Jun 20, 2003
Messages
6,423
This works for me, where Controls that first appeared, left-to-right:

LastName DOB FirstName

Code:
Private Sub Form_Load()
  FirstName.ColumnOrder = 1
  LastName.ColumnOrder = 2
  DOB.ColumnOrder = 3  
End Sub
Now appearing

FirstName LastName DOB

Linq ;0)>
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 02:10
Joined
Feb 19, 2002
Messages
42,981
Or you can write code or manually drag the columns to hide the fact that Access won't let go of an old setting.
 

lana

Registered User.
Local time
Today, 10:40
Joined
Feb 10, 2010
Messages
92
Hi there,
Thank you all for replying.
The problem was a frozen column.!!!
That's why the tab index was not working for that datasheet.


Thanks again.
Cheers
 

Users who are viewing this thread

Top Bottom