Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 208438 - Last Review: June 29, 2004 - Revision: 2.0
ACC2000: Find Does Not Work with Fields Containing # Character
This article was previously published under Q208438
Novice: Requires knowledge of the user interface on single-user computers.
You cannot use the Find command to find fields containing the number sign
(#) character.
The number sign character is a control character in Microsoft Access;
the Find command does not treat it as it does regular characters.
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
- Click Find Next. Note that Microsoft Access does not find the record.
- Repeat step 4, but type Hello[#] in the Find What box.
- Click Find First. Note that this time the record is found.
For more information about finding data, click
Microsoft Access Help on the
Help menu, type
find or replace data in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
For more information about control characters, click
Microsoft Access Help on the
Help menu, type
using wildcard characters in string comparisons. in the Office Assistant or the Answer Wizard, and then click
Search to view the topic.
APPLIES TO
- Microsoft Access 2000 Standard Edition
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate