[FAQ's: OD] How do I show a form at the startup of Access?

[RobDog888]

Using the Startup management form inside Access ("Tools > Startup..." menu) you can designate a Form to be displayed upon the opening of your Access database. You can also customize your database's appearance and which database objects are to be displayed.


Your Startup management form will look like this (Access 2003):

Fig. 1




Another method to show a form at the startup of Access is to write some macro code Access' autoexec macro.


Within this Form you can:

• Set a Title for display in Access' Titlebar caption.
• Assign a custom Icon for the main Access application and any Forms/Reports.
• Enable various Menu/Tool Bars
• Misc. settings.

I have changed the app Title, Icon, and set Form1 as the startup object to display when opening my database as seen in Fig. 1. The resulting Icon and Caption change are shown in Fig. 2.

Fig. 2



So with a few simple changes you can customize your Access database's appearance and behavior in a matter of seconds.