Hello all!

How can I allow changes, additions, etc to the records in a subform in datasheet view but not allow changes to the column widths? I can't seem to find a way of locking the column widths without locking the data as well.

Thank you!!

Use the ColumnWidth property. Have a look in the help for the correct usage.

David

I set it several times but, in the subform, the user can still adjust the headers in the datasheet view.