Prevent user to change the size or order of the columns of datasheet subform in Acces

[mshakeelattari]

I have a form with subform in datasheet view. I want end user not to modify the order and size of the columns. How is it possible?

[ADezii]

1. Should a User change the order of Columns in a Datasheet Subform, I do not think that that change will persist once the Form is Closed then Opened.
2. Using the Order Details Subform of the Northwind Sample Database as an example, at any given time the Column Widths in the Subform can be set to that Column's Optimal Width, as in:
   

   Const conOPTIMAL_WIDTH = -2
    
   With Me![sbfOrderDetails].Form
     ![Product ID].ColumnWidth = conOPTIMAL_WIDTH
     ![Quantity].ColumnWidth = conOPTIMAL_WIDTH
     ![Unit Price].ColumnWidth = conOPTIMAL_WIDTH
     ![Discount].ColumnWidth = conOPTIMAL_WIDTH
     ![Extended Price].ColumnWidth = conOPTIMAL_WIDTH
     ![Status Name].ColumnWidth = conOPTIMAL_WIDTH
   End With
    

3. Hope this is what you are looking for.

[NeoPa]

Like Button :-)