The Beginner’s Guide on Access Controls (Part II)

Layouts are a great way to ensure users are able to easily use your forms and reports. By understanding your layout options and the basics of working with them, you will be able to offer a more user-friendly database to end users.

Controls can be tricky. By ensuring the layout is done correctly, you can ensure that the controls continue to work as intended. The following will help you develop the right layout or update an existing one.

Each form and report needs to be considered as a standalone component. You may be able to update an existing report or form, in which case your task is relatively simple. New reports and forms will probably take a bit more time as you decide whether a new layout is best.

Correcting Major Issues

Before you start making changes, make sure you have a current backup of all your data. If you encounter any issues while working with the layouts, make sure you pay attention to the data. If you find that data is missing or incorrect when you finish, you may need to have a specialist repair Access error before you release the changes to your users.

Creating a Layout

For new forms and reports, if you decide to create a new layout, it is pretty simple. Just make sure you plan how you want to align the fields before getting started.

  1. Click on the control where the new layout will be added. If you would like to add the same layout to several controls, you can highlight them by holding SHIFT and clicking on each of them.Click On The Control
  1. Go to the Arrange tab and click on your preferred layout (Tabular or Stacked) under the Table group. Click Tabular Or Stacked On The Arrange Tab

Access automatically applies the selected layout with the controls you choose to add.

Changing the Layout

If you already have a layout applied that is no longer what you need, you can switch it. Or you may have copied a form or report and need to adjust to the other type of layout. It will only take a minute or two to complete the change.

  1. Highlight the cell with the layout you wish to change.
  1. Go to the Arrange tab and Select Layout from the Rows & Columns group. Highlight The Cell Then Click Select Layout
  1. Go to the Arrange tab and click on your preferred layout (Tabular or Stacked) under the Table group. Click Tabular Or Stacked On The Arrange Tab
  1. Verify the change once it is saved.

Splitting Your Layout

If you need both types of layouts, you can split the table.

  1. Press SHIFT and then select the cell or cells you want on the second layout. The current layout will remain the same. Only the selected cells should move to the new layout.Select The Cell You Want On The Second Layout
  1. Go to the Arrange tab and click on your preferred layout (Tabular or Stacked) under the Table group. Click On Your Preferred Layout

Adding and Removing Columns and Rows

If you find that you either need more information or less information, you can update what you have instead of re-creating the table.

Complete the following steps to add a column or row.

  1. Click on the cell that is beside where the new column or row will be.
  1. Go to the Arrange tab and select one of the following.
  • For a new column, click Insert Left or Insert Right under the Rows & Columns group.
  • For a new row, click Insert Above or Insert Below under the Rows & Columns group. Add A Column Or Row

Complete the following steps to remove a column or row.

  1. Click a cell that is in either the column or the row you wish to delete.
  1. Go to the Arrange tab and click Select Column or Select Row under the Rows & Columns group.Remove A Column Or Row
  1. Press Delete.
  1. Verify the correct column or row was deleted.

Author Introduction:

Victor Ren is a data recovery expert in DataNumen, Inc., which is the world leader in data recovery technologies, including repair xls data corruption and word recovery software products. For more information visit www.datanumen.com

Comments are closed.