Form datasheet - locking the column widths

[Adam]

Hi All,

I have a subform which is set to show as a datasheet view. I want to be
able to lock the column widths to that the user cannot change these.

I cant see to be able to do this.

Does anyone know how, or if its even possible?

Many Thanks

Adam

 

[doodle]

Adam,

You could change your datasheet to continuous. Then the width would be
specified by the text box width and the user would be unable to change
it. Continuous forms can be manipulated to look very similar to
datasheets.

Assuming you have a close button on your form, you could specify on the
close event to not save changes. The records are automatically saved
but this would prevent the user from saving any of their changes to the
form design. This will not prevent them from resizing the columns at
runtime.

-doodle