Feb 9, 2010 #1 maxhugen Programmer Joined May 25, 2004 Messages 498 Location AU Does anyone know of a method to close the Form/Report Properties window using VBA? MTIA Max Hugen Australia
Does anyone know of a method to close the Form/Report Properties window using VBA? MTIA Max Hugen Australia
Feb 10, 2010 2 #2 Blorf Programmer Joined Dec 30, 2003 Messages 1,608 Location US The only thing I can think of is setting the forms and reports property "Allow design changes" to design view only. You can run code that will set that property for all forms and reports, but you cant set that in the form when it's open. ChaZ There Are 10 Types Of People In The world: Those That Understand BINARY And Those That Don’t. http://www.thelegacyreturns.com/ Upvote 0 Downvote
The only thing I can think of is setting the forms and reports property "Allow design changes" to design view only. You can run code that will set that property for all forms and reports, but you cant set that in the form when it's open. ChaZ There Are 10 Types Of People In The world: Those That Understand BINARY And Those That Don’t. http://www.thelegacyreturns.com/
Feb 10, 2010 Thread starter #3 maxhugen Programmer Joined May 25, 2004 Messages 498 Location AU Just what I needed. Thanks! Max Hugen Australia Upvote 0 Downvote
Feb 11, 2010 #4 PWise Programmer Joined Dec 12, 2002 Messages 2,633 Location US ChaZ: I was long looking for something like this Have A Pink one Upvote 0 Downvote