Taborder and sequence of columns in datasheet

T

Tore

I have a form with a subform. In the subform there is a datasheet where the
operator do edit, add, delete.

The sequence of the columns in the subform datasheet is set in design mode
by setting taborder. The operator can select a column and drag it with the
mouse to alter the sequence of the columns.

How can I prevent the user from dragging the columns and changing their
sequence?

Alternatively I could repair the sequence of columns every time the subform
is opened. How can I do this in vba?

Regards

Tore
 
A

Al Campagna

Tore,
You could make a continous subform that looks just like a datasheet
subform.
You'll find you have a lot more flexibility with continuous than
datasheet. (Headers, Footer totals, colors, etc...)
--
hth
Al Campagna
Microsoft Access MVP
http://home.comcast.net/~cccsolutions/index.html

"Find a job that you love... and you'll never work a day in your life."
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top