View Full Version : Form in Datasheet view needs locking - How?


Joseph Yeo
11-13-2001, 06:16 PM
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
11-14-2001, 05:51 AM
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
11-15-2001, 11:03 PM
Thanks.