Kiosk Forms

One of my favorite tricks with forms in Access has always been what I call a kiosk form. A kiosk form is a form that takes up the entire screen and is one that you might find in a store or shopping center displaying information. For example, a real estate kiosk might display homes for sale in the area. These screens often take up the entire screen so your attention is drawn to the content on the screen. Interesting scenarios for a kiosk form include:

  • Real estate information
  • Dashboards
  • Store directory
  • Product searches

You can create a kiosk form in Access by maximizing a popup form. When you do this, the form will cover the entire desktop including the Access window and give it this kiosk effect. This is really easy to do by using the Maximize macro action in the Open event, or with the following line of code:

DoCmd.Maximize

If the form appears to flicker when being maximized, you might consider suspending screen updates using the Echo method as follows:

With DoCmd
    .Echo False
    .Maximize
    .Echo True
End With

Be sure to set the Popup property of the form to Yes to see this in action. The BorderStyle property of the form also has an impact on the form:

  • When the BorderStyle property is set to None or Dialog, the form will also cover the Windows Taskbar
  • When the BorderStyle property is set to Single or Thin, the form will not cover the Windows Taskbar

Office Blogs Comments

Comments: (3) Collapse

  • I use "kiosk forms" a lot. Unfortunately, I use them for all the wrong reasons. It would be really nice to see more support for forums that don't have the full Access development application in the background. I use kiosk forms to lock people out of all that background stuff, to force them through my buttons. I realize you can use pop up in these cases as well but I have had times where that has the opposite of my intended effect because the Access background and the form get separated on screen and end up hogging the entire screen. If that's going to happen, I'd just as soon make it look intentional and use kiosk type forms.

  • We design POS systems using these kiosk forms. Some useful tips: - Load all the forms your application uses and then switch the visibility on and off to move between them in order to improve the screen flicker problem. - It's all worth turning off the 'CanGrow' properties of sections, which seem to induce flicker even though they are 'print-only'. - Avoid using anchored tabs or anchored controls on tabs since these flicker constantly. They tend not to make great GUI design elements in kiosk apps either. HT

  • Some nice tips. I've programmed in VBA for many years but have never seen or thought of using With/End With in conjunction with DoCmd. You learn something new everyday! Many Thanks.

Comments

Comments: (loading) Collapse