MS Access: Forms

Tutorials

• Form Basics (Understanding and creating forms) in Access 2010 | 2007 | 2003

Navigation Pane (Access 2010 and 2007)

• Display forms in the Navigation Pane in Access 2013 | 2010 | 2007
• Display all objects (tables, queries, forms, reports, modules) in the Navigation Pane in Access 2013 | 2010 | 2007
• Display tables and related objects in the Navigation Pane in Access 2007

Design

• Create form in Access 2010 | 2007 | 2003
• Add objects to form in Access 2010 | 2007 | 2003
• Resize objects on form in Access 2010 | 2007 | 2003
• Display the form header in design view in Access 2007 | 2003
• Display the form footer in design view in Access 2007 | 2003
• Group controls in a form in Access 2007 | 2003
• Ungroup controls in a form in Access 2007 | 2003
• View form in Form View in Access 2010 | 2007 | 2003
• Save form in Access 2010 | 2007 | 2003

Form Properties

• View Form properties in Access 2010 | 2007 | 2003
• Record Source property in Access 2010 | 2007 | 2003
• Caption property in Access 2010 | 2007 | 2003
• Default View property in Access 2010 | 2007 | 2003
• Auto Center property in Access 2010 | 2007 | 2003

Formatting

• Conditional formatting in Access 2007 | 2003
• Change the background color of a text box based on whether a value has been entered in Access 2007 | 2003
• Change the background color of a text box when the text box value changes in Access 2007 | 2003
• Conditionally change the background color of a text box on a Continuous Form in Access 2007 | 2003
• Center a form in the application screen in Access 2007 | 2003
• Change AutoFormat (background style) for a form in Access 2007 | 2003
• Set form colors to be consistent on different computers in Access 2007 | 2003
• Set tab indexes in Access 2007 | 2003
• Remove minimize, maximize, and close buttons from a form in Access 2007 | 2003
• Picture as background of a form in Access 2007 | 2003
• Define a custom format for a Date/Time field on a form in Access 2007 | 2003
• Set up a text box to flash red/black when a date is past due in Access 2007 | 2003

Tab Controls

• Establish tab order between objects in tab control pages in Access 2003
• Set focus on first text box on first tab page and go to next record in Access 2003

Calendar

• Popup calendar in a form/subform in Access 2007 | 2003

Subforms

• Populate subform data automatically (one to many relationship) in Access 2003
• Refresh the contents of a subform whenever the record in the main form changes in Access 2003
• Display a particular subform based on a combo box selection in Access 2003

Combo boxes

• Filter records based on a combo box selection in Access 2007 | 2003
• Populate one combo box based on the selection of another combo box in Access 2007 | 2003

Startup

• Automatically start up a form when database is opened in Access 2007 | 2003

Searches

• Create a form where you can perform searches and display search results in Access 2007 | 2003
• Create a form where you can search any text field in a table in Access 2003
• Create a form where you can perform both text and numeric searches in Access 2003
• Create a form where you can perform up to 3 search criteria that can be either text and numeric searches in Access 2003

Form's Close button

• Disable Close button on a Form in Access 2007 | 2003
• Enable Close button on a Form in Access 2007 | 2003

Miscellaneous

• Check if a form is loaded in Access 2007 | 2003
• Prompt for changes to be saved in Access 2007 | 2003
• Use a control in a SQL statement in Access 2007 | 2003
• Duplicate a record in Access 2007 | 2003
• Refresh data in a form in Access 2007 | 2003
• Redraw a form in Access 2007 | 2003
• Set a default value for a text box when a new record is created in Access 2007 | 2003
• Prevent the mouse wheel from scrolling through records in a form in Access 2003
• Set the background color of a button in Access 2007 | 2003
• Disable the Esc key in a form in Access 2007 | 2003
• Display on a form, the number of related records from another table in Access 2007 | 2003
• Sort a form's records based on the value of a calculated field in Access 2007 | 2003
• Load a form into memory, but do not display it in Access 2007 | 2003
• Change the tab order on a form with VBA code in Access 2003
• Replace system error message with a custom message in Access 2007 | 2003
• Set the focus on the first field in a form whenever a record is viewed in Access 2003
• Open a Form from another Form (disabling the parent form until the child form is closed) in Access 2007 | 2003
• Set the value of a textbox based on the value of another textbox in Access 2003
• Set up a text box to display the difference between two dates in Access 2007 | 2003
• Add an independent label on a form in Access 2007 | 2003