Microsoft KB Archive Search

Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

  1. Home
  2. ACC2000: Invalid ControlSource Property Values Are Erased in Data Access Pages

ACC2000: Invalid ControlSource Property Values Are Erased in Data Access Pages

View products that this article applies to.

This article was previously published under Q225917
Moderate: Requires basic macro, coding, and interoperability skills.

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

↑ Back to the top

Symptoms

When you type an invalid value in the ControlSource property of a control on a data access page, Microsoft Access returns one of the following error messages and erases the value:
Invalid property value.
-or-
The expression "expression" is not valid.
-or-
The setting you entered isn't valid for this property.

↑ Back to the top

Cause

Because the ControlSource property value is invalid, Access erases the invalid entry so that you can re-enter a valid value.

↑ Back to the top

Resolution

Type a valid value in the ControlSource property.

For more information about valid ControlSource property values, click Microsoft Access Help on the Help menu, type ControlSource Property in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

↑ Back to the top

More information

Steps to Reproduce Behavior

  1. Open the sample database Northwind.mdb.
  2. In the Database Window, click Pages under Objects, and then click New.
  3. In the New Data Access Page dialog box, click Design View, and then click OK.
  4. Add a text box to the unbound section of the page.
  5. If the Properties window is not visible, on the View menu, click Properties.
  6. On the Data tab, type =nothing for the ControlSource property. Press ENTER.
  7. When the error message appears, click OK. Note that the text that you typed in the ControlSource property is gone.

↑ Back to the top

Keywords: KB225917, dapprob, kbprb, accdap, kbdta, kbdap

↑ Back to the top

Article Info
Article ID : 225917
Revision : 1
Created on : 12/12/2002
Published on : 12/12/2002
Exists online : False
Views : 306