Access Tips

Home  |  Letter Aid  |  Links  |  Reminder  |


This page has tips on Access Forms, Queries, Reports, Modules and VBA programming. The notes that I made as a student of Access have been used to build this section.


# While designing a Form, one or more Text boxes may automatically get a border around them. To get rid of the border, hold down Shift key and select all the Text boxes that show a border. Then click the Properties button in the Form Design Toolbar. You can also right click on any of the selected Text box and click on "Properties" on the short cut menu that is displayed. This brings up a dialog box titled "Multiple selection". In this dialog box click the "Format" tab and set the "Border Style" property to "Transperent". This procedure also works with Reports.

# To start a new line in a Lable box hold down either Shift or Ctrl and press Enter. Each Lable box can store a maximum of 2048 characters.

# In Form or Report design each user defined formula like [Hourly Pay]*[Hours Worked], sub procedure or built-in function like sum() must only be placed in Unbound Text boxes. The Unbound Text box containing the formula or function must have an assignment operator (=) in it. You must place the formula or function in the "Control Source" property of the Unbound Text box.

# Tab Order is the order in which each object on the form gets focus when the users presses the Tab key. To change the Tab Order for a form, first select the form by clicking in its top left corner. A black square will be shown to indicate that the form has been selected. Now right click the forms' Title Bar and choose "Tab Order..." from the menu. You can specify any order you want in the "Custom Order:" section.

# In relational databases One to Many relationship is also known as parent-child or master-detail relationship.

# You can prevent the Database window from being shown each time the database starts. To do this open the database, from the Tools menu click on Startup... then in the Startup dialog box remove the Tick for "Display Database Window". You can also specify a form that opens each time the database starts. This becomes your Startup Form.

# To control the appearance of your form try experimenting with the following Form Properties: Scroll Bars, Record Selectors, Dividing Lines, Control Box, Min Max Buttons and Close Button. Change each property one at a time and see the effect it has on the forms' appearance. The Min Max Buttons and Close Button are common in most window forms. If you are using Internet Explorer, all 3 buttons are seen in the top right corner. If the Control Box Property is set to "No" then Min Max and Close buttons will NOT be shown in the Form View.

# To prevent users from changing the value in a Text box set the "Locked" property of the Text box to "Yes". The Locked property is in the Data tab of the Text box property dialog box.

# The Status Bar Text property of a Text box, Combo Box, Button etc. can be used to display Help text for that control. When the control gets focus the text entered for its Status Bar Text property is shown in the Status Bar at the bottom left side of your screen. Status Bar Text property is in the Other tab and is NOT available for Lables.

# The ControlTip Text property of a Text box, Combo Box, Button etc. can be used to display Help tip for that control. The text entered for its ControlTip Text property is shown as floating Tip when the cursor hovers over the control. ControlTip Text property is in the Other tab and is also available for Lables.


You can include your comments about this site in our Guest book below.

| View Guestbook | Sign Guestbook |