Been trying to figure this one out.
I have a form with a subform. The subform is a datasheet and i want to set the column width for the columns in the datasheet.
When i put these in the subform upon loading, i get an error when i open the main form.
Here's my code:
Forms![frmOrderInOverzicht].RowHeight = 250
Forms![frmOrderInOverzicht]![TransOrder].ColumnWidth = 1500
Forms![frmOrderInOverzicht]![Artikel].ColumnWidth = 1000
Forms![frmOrderInOverzicht]![Omschrijving].ColumnWidth = 3500
Forms![frmOrderInOverzicht]![ArtikelLev].ColumnWidth = 1800
Forms![frmOrderInOverzicht]![OmschrijvingLev].ColumnWidth = 3500
Anybody any idea how i could manage that column witdh of a subform (that is a datasheet)?
I have a form with a subform. The subform is a datasheet and i want to set the column width for the columns in the datasheet.
When i put these in the subform upon loading, i get an error when i open the main form.
Here's my code:
Forms![frmOrderInOverzicht].RowHeight = 250
Forms![frmOrderInOverzicht]![TransOrder].ColumnWidth = 1500
Forms![frmOrderInOverzicht]![Artikel].ColumnWidth = 1000
Forms![frmOrderInOverzicht]![Omschrijving].ColumnWidth = 3500
Forms![frmOrderInOverzicht]![ArtikelLev].ColumnWidth = 1800
Forms![frmOrderInOverzicht]![OmschrijvingLev].ColumnWidth = 3500
Anybody any idea how i could manage that column witdh of a subform (that is a datasheet)?