Reactivate "Require Variable Declaration" and "Option Explicit"
The option "Require Variable Declaration" in the VBA Editor's Options dialog is deactivated by default. So "Option Explicit" is not added automatically to new modules. If unexperienced programmers forget to declare variables this can result in unexpected errors.
It seems that you could easily change the default value of this option to "activated" (it is one key in the windows registry).
I don't even understand why the default value of this option was changed.
Suggestions related to VBA editor should be posted in the Office Developers User voice site here – https://officespdev.uservoice.com/
@Joe – please create two separate suggestions for your requests in the comment so that people can vote on them.
I couldn't find this at https://officespdev.uservoice.com/ so I have posted it there as 'Make the default value of "Require Variable Declaration" in the VB Editor to be True'. If interested, please do pop over there and add your votes. Note that you get extra votes on top of the ones we have here in the Access section. https://officespdev.uservoice.com/forums/224641-general/suggestions/16435576-make-the-default-value-of-require-variable-declar is the relevant location.
I'm a bit surprised that the Access team ever let this become how it is. I'm currently working through the code from a previous developer where Option Explicit was left out. It's horrendous.
David Peel commented
@Michal [MSFT] - do you even use Access? How do you see this as 2 suggestions?
[Deleted User] commented
+Infinity to Joe's extra suggestions!
AND ... while we are at it .... in Table Design for a Text data type ... Make the "Allow Zero Length Strings" property default to ... .... .... ** FALSE ** ... please !!!
AND ... on the Table Property Sheet ... make the Default for "Subdatasheet Name" .... [None] instead of [Auto] . PLEASE.
It was changed back in Access 2010, I think. It was pointed out to them during the beta testing, but not sorted out then... or in Access 2013 ... or in Access 2016.