Permit the Properties Window to be displayed in Form View again
In Access 2003, an object on an open form could be right-clicked | Properties chosen, and then the [Event Procedure] of the object could be displayed. This allowed the developer to open the code behind an object while the form was open and working. This was highly productive for the developer, as the code for open objects could be adjusted, tests run, and further objects adjusted and so on.
This was removed from Access 2007+ and is a HUGE drag on developer productivity as either the form must be constantly shifted back-and-forth from Design View to Form View --losing the view of the data and setting off OnLoad events each time --, or the developer must navigate the VBA IDE separately from the object -- which defeats the 'Visual' part of Visual Basic for Applications. It would be good if this ability could be toggled in Options, so the dev who wants it can turn it on, and it could be turned off for production and devs who don't want it.
Allowing turning on the Property Sheet in the Options would be nice, as opposed to the way it was done before. Layout view solves some of the issues but it doesn't run code.