I am working with an MS Access 2007 form that displays has its property default view set to datasheet. The forms controlsource is set to a sql statement and the textbox controls on it are bound to the datasource or date retrieved from the sql.
I noticed that when I open this form (in datasheet view), there is nothing preventing a user from changing the ordering of columns. It's easy for any person using the form to click on a column, select it, and drag to another location. I need to prevent users from making any changes to the display of the datasheet.
Is there a property of the form that will prevent this? I've already tried setting "moveable" property to No, "allow edits" property is set to no as well but neither, prevents a user from changing the order of columns. Please let me know if any clarification is needed.