Microsoft KB Archive/225941

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

Article ID: 225941

Article Last Modified on 7/16/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



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

 * 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: kbnofix kbdap kbprb KB225941

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.