How To Open Your MS Access Form In Full Screen: Discover The 10 Key Properties Required
- June 29, 2017
- Posted by: marlenedubois
- Category: Home Health Aide Training
Once upon a time you loaded your Access database, found the starting form (screen) in addition to also also navigated between additional related objects. Actually, This kind of wasn’t always the case although general Microsoft Access users certainly engaged in This kind of approach when designing a database leaving the end-user disorientated in addition to also also de-motivated in utilising the firms application.
To help streamline your application generating the item user-friendly in addition to also also more conducive to use, real database developers took advantage of the many properties in Access which included the form’s property sheet too.
In This kind of article, I want to cover the 10 key properties required in addition to also also when synchronised together the item forms a smooth start-up screen environment as the Access form loads in a full screen mode removing any tempting in addition to also also unwanted elements. This kind of approach ends up having a polished in addition to also also professional look in addition to also also feel too which can be highlighted with some simple although optional automation using Access VBA code in addition to also also an auto macro.
Design your form adding all the components within the normal manner as if the form was manually called then save your adjustments before changing the key properties. In addition to the standard controls for your Access form, make sure you have added a ‘Close’ command button in addition to also also can be coded to close the form.
Next, let’s add the 10 key properties:
- Auto Resize – This kind of property can be set to ‘Yes’ in addition to also also will automatically shape the form as the item loads.
- Auto Center – This kind of property can be also set to ‘Yes’ in addition to also also will sit dead centre should the form not fully load in a full screen view which maybe a desired effect should developers wish to change the size of a form. This kind of will sit comfortably with the first property mentioned.
- Border Style – Set This kind of property to ideally ‘Dialog’ though the item can be also set to ‘None’ since the item can be going to be in a full screen view. The ‘Dialog’ option just follows the rules about when a screen has the focus user can optionally control moving in addition to also also sizing of a form.
- Control Box – Set This kind of property to ‘No’ to switch of the ability to show the control menu for a window (i.e. top left corner icon in a window).
- Min Max Buttons – Also set to ‘None’ to stop users through resizing the window to either a minimized, restore or maximized state.
- Close Button – Set This kind of property to ‘No’ to switch off the ‘x’ icon in a window which of course will close the form. This kind of must only be switched off if you have an alternative way to close a form (namely the command button mentioned earlier).
- Pop Up – This kind of property can be set to ‘Yes’ to make sure This kind of form has the focus in addition to also also viewed on top of any additional previously opened form (if applicable).
- Modal – This kind of must be set to ‘Yes’ in addition to also also will behave as a real dialog box in order which users cannot navigate away through This kind of form until they use an alternative way to formally close the form.
- Caption – This kind of property can be the title bar caption which can be anything you like to display at the top of the form. I tend to use This kind of for database title along with some clever coding to welcome the logged in user (if applicable) or just leave the item blank.
- Allow Datasheet, PivotTable in addition to also also Chart Views – All three properties deemed to be one collection here are set to ‘No’ as you only want to show the default view as set to ‘Single Form’.
today the simple VBA code can be to be attached to the loading form’s event (On Load) by adding DoCmd.Maximize in between the sub in addition to also also end sub signature which will turn your form into a full screen view showing all the clean elements of the form in its full glory.
The final in addition to also also optional part can be to add a macro called ‘AutoExec’ (a specially reserved macro name) which triggers itself when the database file can be loaded. In This kind of macro, you add the ‘OpenForm‘ action to call your form.
Hopefully, you contain the essentials in place to which you can today add further refinement to taste. Happy ever after!