Database banner image.

A really easy addition to any Microsoft Access database application is a Display Form, or what is commonly referred to as a Splash Screen that opens automatically when the database is opened. A Splash Screen is what appears when you open almost any application, for example, Microsoft Word. A combination of some of the changes we are going to make to the Form’s properties can effectively “lock” you out of your database. For this reason, make sure that Step 2 below is working correctly before you tackle Step 3!

In this post:

  1. Create
  2. Automate
  3. Settings
  4. Implement

1. Create

  1. Open your database and create a new, blank form
  2. Save the form as frmSplash
  3. Add labels and graphics etc to your form using the relevant controls

2. Automate

To get your Splash Screen to close automatically after elapsed time:

  1. Activate the Event tab of the property sheet for frmSplash
  2. Enter a value of 3000 for the Timer Interval (the interval is an integer value representing milliseconds)
  3. Click in the On Timer event and click on the 3 dots on the right & select the Macro Builder option
  1. The Macro Tools Design tab will now open
  2. Click in the Add New Action dropdown & select the CloseWindow option
  3. Set the object Type to Form
  4. Select frmSplash from the Object Name
  5. and set the Save option to No
  6. Save the macro
  7. Close the macro

Be very careful when you change the settings as you could effectively block yourself out of your database!

3. Settings

Set the properties of the form as follows:

  1. Format tab
    1. Default View: Single Form
    2. Auto Center: Yes
    3. Auto Resize: Yes
    4. Fit to Screen: No
    5. Border Style: None
    6. Record Selectors: No
    7. Navigation Buttons: No
    8. Dividing Lines: No
    9. Scroll Bars: Neither
    10. Control Box: No
    11. Close Button: No
    12. Min Max Buttons: Neither
    13. Moveable: No
  2. Other tab
    1. Pop Up: Yes
    2. Modal: Yes

Save the Form and switch to Form View: the Form will display for 3 seconds and then close (as per the Macro you created in Step 2 above).

The final result is a Form with no Title Bar, controls, or borders that displays neatly in the center of the screen.

4. Implement

To implement your Splash Screen:

  1. Select File » Options
  2. Select the Current Database section
  3. Select frmSplash from the Display Form dropdown.
  4. Add an Application Title while you are at it
  5. Click the OK button

Close and re-open your database to see your Splash Screen in action!

Of course, if you have a menu for your application then you can adapt the above process so that the Splash Screen is closed and your menu is opened.

For another stylish option for your database application, read the post Add an Application Icon to your Access database application

By MisterFoxOnline

CAT Educator

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.