DATASHEET --- Allow Design Changes: Design View Only DOES NOT WORK

[replyrpatil]

I have a sub form in DataSheet view and I would like to lock the design so that the User should not change the layout

Even when I set the property of the Datasheet “Allow Design Changes: Design View Only” users are able to unhide the hidden columns and they can also change the size of the column by dragging the column end line



Does any one know how to lock the design of datasheet ( I am using this sub form datasheet for data entry but do not want users to change the layout)



Thanks
Rahul

 

[Hap007]

Dear Rahul,

Instead of using a Datasheet view, set the property to 'Continuous Forms'

Then, on the form, create a detail line that just has the fields, laid out, in a single line on the detail line that you want displayed. If you need addtional fields, for some reason, but do not want them displayed, place the fields on the form and set the field visible property to false.

This should work for you.

Hope this helps,
Hap...

Access Developer

http://www.fcs-software.com/fcsaccessdev.html

Access based Add-on Solutions
Access Consultants forum

http://www.tek-tips.com/threadminder.cfm?pid=1121