Is there any way to determine, using VBA, whether a form is in Design Mode?
Competent Performer
Windows Vista 
Access 2010 32bit
Is there any way to determine, using VBA
Competent Performer
Windows 7 64bit Access 2013
Very Inert Person
Windows 7 32bit Access 2007
If you enter "CurrentProject.AllForms("formName").CurrentView=" (without the RED quotes) in the immediate window of the VB editor (or I suppose in a code module) Intellisense should provide you with a list of properties, amongst which you will see acCurViewDesign.
So you can test a given form by name. I've read that this will not work for sub forms. From what I see at the linked page, it assigns 0 to two user defined constants and no doubt works, but the information I posted shows how to get at the form view properties while coding. Not to say that is better, just another way.
Last edited by Micron; 01-02-2016 at 10:27 PM. Reason: added comment on linked page
The more we hear silence, the more we begin to think about our value in this universe.
Paraphrase of Professor Brian Cox.
Toggling Design Mode On/Off
Can't open form in Design mode
Subform shows as continuous in design mode but as datasheet in form mode??
Posting Permissions
Reply With Quote