Feb 9, 2010 #1 maxhugen Programmer May 25, 2004 498 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 Dec 30, 2003 1,608 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 May 25, 2004 498 AU Just what I needed. Thanks! Max Hugen Australia Upvote 0 Downvote
Feb 11, 2010 #4 PWise Programmer Dec 12, 2002 2,633 US ChaZ: I was long looking for something like this Have A Pink one Upvote 0 Downvote