Form in Datasheet view needs locking - How?

[Joseph Yeo]

I have a form in datasheet view. I would like to prevent users from dragging and modifying the column width. Please tell me how to do this.
Why use a datasheet? because I need the freeze column ability not available in a continuous form.

 

[DJN]

I don't think you can prevent a user from dragging and modifying the column width. You can however, set the column width so that even if the width is altered it will revert back to whatever you set it to when the form is reopened in datasheet view. Use the ColumnWidth property. e.g. Forms![frmYourFormName]![YourFieldName].ColumnWidth = 100
You will need to experiment to find what width you need.

 

[Joseph Yeo]

Thanks.