Keep Datasheet Format

[Eddy]

Dear all,

I have a Main form and a subform, where the subform is default in Datasheet
view and only allowed to display as datasheet view.

I have well designed the display of the datasheet view (fields ordering,
columns size...etc). But, when the user reorder, hide or adjust the format of
subform through Main form, their modification saved and will adopt the
original format.

I want to keep my original format for all users as default format, and allow
them to reorder, hide or adjust the columns.

Thanks!

Eddy

 

[Allen Browne]

In the Open event of your form, set the properties such as:
- FrozenColumns
- ColumnWidth
- ColumnHidden
- ColumnOrder
- RowHeight

Since you are explicitly setting these whenever the form opens, it comes up
the way you intend, but the user can still rearrange at will for that
session.

 

[Eddy]

It works!!
Thanka a lot!!

Eddy

In the Open event of your form, set the properties such as:
- FrozenColumns
- ColumnWidth
- ColumnHidden
- ColumnOrder
- RowHeight

Since you are explicitly setting these whenever the form opens, it comes up
the way you intend, but the user can still rearrange at will for that
session.