Hi
Access 2007, .mdb
I'm almost embarrased to ask this question but how does one drag and drop columns in a (subform)datasheet to change the order?
I know about .ColumnOrder and acSaveYes/No to retain the changes... so I know how to manipulate in code but for the life of me I cannot drag a column.
I select a col, hold the shift key but as I try to drag it, either the column selection springs over to the first (leftmost) column or I get the black circle (with the oblique line thru' it). I've 'unhidden' all columns, 'unfrozen' all columns, I've even set AllowEdits to true but no joy.... ?
thnx
Access 2007, .mdb
I'm almost embarrased to ask this question but how does one drag and drop columns in a (subform)datasheet to change the order?
I know about .ColumnOrder and acSaveYes/No to retain the changes... so I know how to manipulate in code but for the life of me I cannot drag a column.
I select a col, hold the shift key but as I try to drag it, either the column selection springs over to the first (leftmost) column or I get the black circle (with the oblique line thru' it). I've 'unhidden' all columns, 'unfrozen' all columns, I've even set AllowEdits to true but no joy.... ?
thnx
