ACC2000: Field May Be Added to Unexpected Section When You Add Field to a Data Access Page (225941)

Microsoft Access 2000

This article was previously published under Q225941

Moderate: Requires basic macro, coding, and interoperability skills.

This article applies to a Microsoft Access database (.mdb) and to a Microsoft Access project (.adp).

SYMPTOMS

In a data access page, if you add a field from the field list to the page, the field may be inserted into a section of the two-dimensional area even though the one-dimensional area has focus.

CAUSE

Access automatically inserts fields from the field list into the two-dimensional area if two-dimensional area contains a header, footer, or unbound section.

RESOLUTION

Instead of adding the field to the page by double-clicking it or by clicking Add To Page, drag the field onto the one-dimensional section.

MORE INFORMATION

The two-dimensional area is made up of all the caption, heading, navigation, and footer sections. The one-dimensional section is the area above and below the two-dimensional section, including the heading text.

An easy way to see the difference between the one-dimensional and the two-dimensional area is to press CTRL+R to select the page. Then, on the View menu, click Grid. The area that changes is the two-dimensional section.

Steps to Reproduce Behavior

Start Access and open the sample database Northwind.mdb.
Create a new page in Design view.
If the field list is not visible, on the View menu, click Field List.
Click somewhere in the title where you see the words "Click here and type title text."
In the Field List box, expand Tables, and then expand the Categories Table.
Double-click the CategoryID field under the Categories table. Note that the CategoryID field is added in a section in the two-dimensional area, not the active one-dimensional area.

Modification Type:

Minor

Last Reviewed:

7/16/2004

Keywords:

kbDAP kbnofix kbprb KB225941