Knowledge Base

ACC2000: Error When You Paste a Field into Navigation Section

Article ID: 203383

Article Last Modified on 7/13/2004

Microsoft Access 2000 Standard Edition

This article was previously published under Q203383

Novice: Requires knowledge of the user interface on single-user computers.

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

SYMPTOMS

When you add a control to a data access page or set the ControlSource property of a control on a data access page, you may receive the following error message:

Caption and record navigation section cannot contain bound fields.

The control remains in the caption or navigation section; however, the control will not contain any data in Page view.

The value that you set in the ControlSource property does not remain after you click OK to the error message.

CAUSE

You tried one of the following in a caption or navigation section of a page:

You tried to add a bound control.

-or-

You tried to set the ControlSource property of a control.

RESOLUTION

Delete the control from the caption or navigation section.

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

Steps to Reproduce Problem

Open the sample database Northwind.mdb.
In the Database window, click Pages under Objects.
Click the New button on the Database Window toolbar.
In the New Data Access Page dialog box, click Design View and select the Shippers table in the Choose the table or query where the object's data comes from box; then, click OK.
Click CompanyName, and then click Add To Page.
Select CompanyName. On the Edit menu, click Copy.
Select the navigation section. On the Edit menu, click Paste.

REFERENCES

For more information about the correct placement of controls, click Microsoft Access Help on the Help menu, type data access pages in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: pra

Keywords: kbbug kbfix KB203383