Tab Order

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I've got a continuous form like such:

Account Q1 Q2 Q3 Q4


I would like the movement of the tab to go down into the Account field,
instead of across the Q? fields and THEN down. Can I manipulate the tab
direction?
 
Not like that. The tab order is within a record. You want to move from one
record to the next, then somehow tell Access when you get to the last record
to jump back to the first record, but go to the second column.

As far as I know there is no way to do that.
 
I just tried this and it seemed to work

Set form to Cycle = All Records
Set all but the far left column to Tab Stop = No
Add Keycode like below to all but the far right column

If KeyCode = 13 Then '13 = Enter
Me.SecondColumn.SetFocus
End If

If KeyCode = 13 Then '13 = Enter
Me.ThirdColumn.SetFocus
End If

etc etc...

Then tab moves to the first column of the next record wheras Enter move to
the next column in the current record.

Tony V
 
Sorry - that code is ont he Key Down event


Tony Vrolyk said:
I just tried this and it seemed to work

Set form to Cycle = All Records
Set all but the far left column to Tab Stop = No
Add Keycode like below to all but the far right column

If KeyCode = 13 Then '13 = Enter
Me.SecondColumn.SetFocus
End If

If KeyCode = 13 Then '13 = Enter
Me.ThirdColumn.SetFocus
End If

etc etc...

Then tab moves to the first column of the next record wheras Enter move to
the next column in the current record.

Tony V
Click to expand...
 
Back
Top