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

• Microsoft Access 2000

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

1. Start Access and open the sample database Northwind.mdb.



2. Create a new page in Design view.



3. If the field list is not visible, on the View menu, click Field List.



4. Click somewhere in the title where you see the words "Click here and type title text."



5. In the Field List box, expand Tables, and then expand the Categories Table.



6. 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.

Additional query words: prb 1-D 2-D one-d two-d add to page

Keywords : kbdta AccDAP
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb