TabIndex is not working

[lana]

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]

You need to change the Page Index property of each of the pages on the tab

 

[lana]

Thank you.

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

 

[isladogs]

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]

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]

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]

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!

 

[MajP]

You can set the column order in code. It is a property of a control when used in a datasheet. Does nothing otherwise.
mycontrol.columnorder = x
https://msdn.microsoft.com/en-us/library/office/aa217449(v=office.11).aspx

 

[missinglinq]

This works for me, where Controls that first appeared, left-to-right:

LastName DOB FirstName

Private Sub Form_Load()
  FirstName.ColumnOrder = 1
  LastName.ColumnOrder = 2
  DOB.ColumnOrder = 3  
End Sub

Now appearing

FirstName LastName DOB

Linq ;0)>

 

[Pat Hartman]

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]

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