Order form for datasheet view 1

[SQLScholar]

Hey all,

I have a form which is used as a subform, and in datasheet view.

I added a couple of fields, in the middle. No matter what i do, in datasheet view they appear at the end.

Any ideas how to get these to appear in the correct section.

BTW this is in Access 2k

Cheers

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[RoyVidar]

Drag'n drop the columns (use the header row) in the datasheet view, then save, doesn't work?

Roy-Vidar

 

[SQLScholar]

DOH - think that was the one thing i didnt try!

Thanks

Dan

----------------------------------------
There are 2 types of computer, the prototype and the obsolete!!
----------------------------------------
No D, just plank - and its not my fault

 

[Remou]

This may help some future reader:

http://msdn.microsoft.com/library/d.../vbaac11/html/acproColumnOrder_HV05187081.asp