ACC2000: The Replace Command Does Not Find Null Values (208938)


The information in this article applies to:

  • Microsoft Access 2000
This article was previously published under Q208938
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 click the Replace command on the Edit menu, Microsoft Access does not locate any Null values even though they do exist in the table.

RESOLUTION

To replace Null values in a table, create and run an Update query.

MORE INFORMATION

If you click Find on the Edit menu to search for Null values, the values are located correctly. It is only the Replace command that does not locate Null values.

Steps to Reproduce Behavior

  1. Start Microsoft Access and open the sample database Northwind.mdb or the sample project NorthwindCS.adp.
  2. In the Database window, click Tables under Objects, click Orders, and then click Open.
  3. Position the insertion point in the first row of the Ship Region column.
  4. On the Edit menu, click Replace.
  5. In the Find What box, type NULL.
  6. In the Replace With box, type TEST.
  7. Click Find Next. Note that Microsoft Access indicates the next record in which there is a Null value in the Ship Region column.
  8. Click Replace. Note that Microsoft Access does not locate any Null values in the table even though such values do exist. Instead you receive the following message:

    Microsoft Access can't find the text you specified in the Find What box.

REFERENCES

For more information about the Replace command, click Microsoft Access Help on the Help menu, type replace specific occurrences of a value in a field in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.

For more information about Update Queries, click Microsoft Access Help on the Help menu, type troubleshoot update queries in the Office Assistant or the Answer Wizard, and then click Search to view the topics returned.
Modification Type:MajorLast Reviewed:6/24/2004
Keywords:kbprb kbui KB208938
©2004 Microsoft Corporation. All rights reserved.