Hi,

Access 2003
As far as I can recall, access 2000 and 97 never had the properties sheet re-appearing from design to showing the form. As an upgrade (for some unknown reason) MS have decided to make it appear if you had it open last time (any database) and didn't close it when on a form.

By any database I mean, that if you have a fairly secure db and you have the properties sheet closed, then close it - go to a new db open a form, open the properties window, close the form (save if neccessary). Reopen the 'secure' db and when a form opens, so does the properties sheet.

I know you can just close the sheet, but if a user opened the db and got the properties sheet, they may be inclined to uh nose around ... and in doing so accidentally delete something.

Anyone have a link or some code to get to the properties sheet and close it?