Access 2007 Options On Open Forms

[Ricky1234]

Hi All

I am trying to set the form that launches on open to one from the custom
list. This is so that the Disable Design View Shortcuts/Hide Design UI
option can be used

Cheers

 

[Allen Browne]

Click the Office button (top left.)
Click Access Options (bottom of dialog.)
You will find all the options there.

BTW, don't forget to set your folder as a trusted location.

More info about adapting to the new version:
http://allenbrowne.com/Access2007.html

 

[Ricky1234]

Hi Allen

Thank you for your reply, I have tried this, however it still launches the
form with the Layout and Design View options.

I am trying to build some security so that users do not amend or adjust the
form

cheers

 

[Allen Browne]

Layout view can be disabled for the whole database (through the options), or
for the form (through its properties.)

To block design view, create an MDE (or ACCDE.)