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)

 

[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)>

 

[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