[AccessD] Changing Column Width and Order in mde or accde

[Stuart McLachlan]

If you save the column  order and widths in  "On_Close", try setting them in "on_open"
with Me.ControlName.ColumnOrder = xxx  etc.

  

On 30 Oct 2017 at 14:39, Bill Benson wrote:

> I don't think so. Column order defaults to the order in which the
> fields were added to the data sheet subform. Perhaps what you could do
> however is keep a table with their column and their user name, on the
> back end.
> 
> Make the subform control's sourceobject an empty string, save the
> parent form.
> 
> In the open event of the parent form, open the subform in design view
> (using VBA code), dynamically add fields in the order specified in the
> backend table, save, and close the local subform. Then in the Load
> event of the parent form, re-associate the sourceobject.
> 
> I think at that point the subform's fields will be in the correct
> order.
> 
> Bill
> 
> On Mon, Oct 30, 2017 at 12:27 PM, Rocky Smolin
> <rockysmolin at bchacc.com> wrote:
> 
> > Dear List:
> >
> >
> >
> > I have a form with a sub-form - the subform is datasheet view
> > because the user needs to be able to change the column widths and
> > order.  This works in a mdb and an accdb - the changes are save so
> > when the user returns to the form the altered order and widths are
> > retained and displayed.
> >
> >
> >
> > But while the user can change the order and column widths in the mde
> > and accde versions, the changes are not saved.
> >
> >
> >
> > Is there a workaround for this?
> >
> >
> >
> > MTIA
> >
> >
> >
> >
> >
> > Rocky Smolin
> >
> > Beach Access Software
> >
> > 760-683-5777
> >
> >  <http://www.bchacc.com> www.bchacc.com
> >
> >  <http://www.e-z-mrp.com> www.e-z-mrp.com
> >
> > Skype: rocky.smolin
> >
> >
> >
> >
> >
> > --
> > AccessD mailing list
> > AccessD at databaseadvisors.com
> > http://databaseadvisors.com/mailman/listinfo/accessd
> > Website: http://www.databaseadvisors.com
> >
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>