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

[Bill Benson]

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
>