Microsoft KB Archive/208438

= ACC2000: Find Does Not Work with Fields Containing # Character =

Article ID: 208438

Article Last Modified on 6/29/2004

-

APPLIES TO


 * Microsoft Access 2000 Standard Edition

-



This article was previously published under Q208438



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



SYMPTOMS
You cannot use the Find command to find fields containing the number sign (#) character.



CAUSE
The number sign character is a control character in Microsoft Access; the Find command does not treat it as it does regular characters.



RESOLUTION
To search for the number sign character (or any control character), you must place brackets around the control character. For example, to search for a record containing the text string "hello#", you would enter hello[#].



Steps to Reproduce Behavior
 Open the sample database Northwind.mdb  Open the Categories table in Datasheet view and add the following record:   Category Name: Test Find Description: Hello#  Click in the Description field of any record in the Categories table above the one that you just entered.  On the Edit menu, click Find. Set the following options in the Find in Field 'Description' dialog box:   Find What: Hello# Search: All Match: Whole Field </li> Click Find Next. Note that Microsoft Access does not find the record.</li> Repeat step 4, but type Hello[#] in the Find What box.</li> Click Find First. Note that this time the record is found.</li></ol>

<div class="references_section">