Keep Datasheet Format

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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.
 
It works!!
Thanka a lot!!

Eddy

Allen Browne said:
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.
Click to expand...
 
Back
Top