Changing a datasheets display order

[Kevin]

I have a form in datasheet mode. Is there any way to add code to order the
fields when the header in selected as in Outlook Express or Windows
Explorer?

TIA

 

[Adrian Jansen]

You can order by any field 'on the fly'. Just right-click in a column, and
set the sort order in the popup menu which opens.

--
Regards,

Adrian Jansen
J & K MicroSystems
Microcomputer solutions for industrial control

 

[Malcolm Cook]

sure,

click once to select the column

click again and drag to move it

make sure the columns are not "frozen" (right click on them to do this).

Good luck