Chapter 8: Working with Data on Access Forms
305
l (^) Split Form: Provides two views of the data at the same time, letting you select a record
from a datasheet in the upper section and edit the information in the lower section of the
split form.
FIGURE 8.11
The Continuous Forms setting of the Default view property shows multiple records at once.
There are five separate properties to allow the developer to determine if the user can change the
default view. These include Allow Form View, Allow Datasheet View, Allow PivotTable
View, Allow PivotChart View, and Allow Layout View. The default setting is Yes for all
these properties. If you set the Allow Datasheet View property to No, the Datasheet view com-
mands (in the ribbon’s Views group, the form’s View Shortcuts, and right-click pop-up menu)
won’t be available and the data can be viewed only as a form. If you set the Allow Form View
property to No, the Form view commands won’t be available, and the data can be viewed only as a
datasheet.
Removing the Record Selector
The Record Selectors property determines whether the Record Selector (the vertical bar
shown in Figure 8.11 on the left side of a form with a right-pointing arrow indicating the selected
record) is displayed. The Record Selector is important in multiple-record forms or datasheets
because it points to the current record. A pencil icon in the Record Selector indicates that the
record is being edited. Though the Record Selector is important for datasheets, you probably won’t
want it for a single record form. To remove the Record Selector change the form’s Record
Selectors property to No.
Looking at other form properties
Tables 8.3 through 8.5 list the most commonly used form properties and offers a brief description
of each. You’ll learn more about most of these properties when they’re used in examples in this
chapter and other chapters throughout this book.