Saving rearranged columns in a datasheet form

dantebothermy

My users and I use Access 2003.

We've got a subform in datasheet format. How do I, how do my users save the layout after re-arranging columns?

Thanks

kstevens

Once they are rearranged will they stay that way, or will each person have there own arrangement?

dantebothermy

I'd prefer that each person can have her own arrangement, but I'd be happy to just be able to change the master copy with different arrangements.

kstevens

Expand|Select|Wrap|Line Numbers

 Forms!FormName!NameOfControl1.ColumnOrder = 1

Forms!FormName!NameOfControl2.ColumnOrder = 2

Put this in the onload event. If you wanted it done different for different peiple then you would have to verify who was loggining in and set these differently for each person...
Also, you can hide the coluns progamatically with

Expand|Select|Wrap|Line Numbers

Me.Controls("NameOfControl").ColumnHidden = True

Saving rearranged columns in a datasheet form

re: Saving rearranged columns in a datasheet form

re: Saving rearranged columns in a datasheet form

re: Saving rearranged columns in a datasheet form

Similar Microsoft Access / VBA bytes

/bytes/development

/bytes/it

/bytes/about