Move selected column in a datasheet form to left

[Arthur Fuller]

I have a form in datasheet view with many columns that correspond to the end
of a month date (i.e. columns 5/31/2004, 6/30/2004, etc.).

I can set the focus to the column corresponding to today's date, but I want
to scroll the window so that column is the leftmost.

Actually, the first column is hidden and the second column is frozen, so
what I want is to move the column with focus to be the leftmost column in
the scrolling section of the form.

Any suggestions?

TIA,
Arthur

 

[fredg]

I have a form in datasheet view with many columns that correspond to the end
of a month date (i.e. columns 5/31/2004, 6/30/2004, etc.).

I can set the focus to the column corresponding to today's date, but I want
to scroll the window so that column is the leftmost.

Actually, the first column is hidden and the second column is frozen, so
what I want is to move the column with focus to be the leftmost column in
the scrolling section of the form.

Any suggestions?

TIA,
Arthur

You can set the column order in code:

Private Sub Form_Load()

Me!Qty.ColumnOrder = 1
Me!Product.ColumnOrder = 2
Me!Price.ColumnOrder = 3
Me!TheDate.ColumnOrder = 4

End Sub