In an Access Single Record Form window, the record selector is the gray bar to the left of a record. By selecting the gray bar, the user can print, copy, or delete that particular record. However, you may not want your users to do any of these operations.

For example, say you have an application designed to restrict users to only view the records—not change or delete them. In this case, you will need to delete the record selector from view. To do so, follow these steps:

  1. Open the form in Design view.
  2. Double-click the Form Selector button.
  3. In the Form properties sheet, under the Format tab, click in the Record Selectors property and select No from the drop-down list.

You can still have users print or copy a record—simply add a command button to the form that allows them to do the functions allowed by your application.

Miss a tip?

Check out the Microsoft Access archive, and catch up on our most recent Access tips.

Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.