ACC2000: Wrong Results Using Filter By Form on Hyperlink Field

MORE INFORMATION

Steps to Reproduce Behavior

1. Create a new table called tblTest:

         Table: tblTest
         -------------------------
         Field Name: ID
            Data Type: AutoNumber
         Field Name: testHyperlink
            Data Type: Hyperlink
   					

   
   
2. Create a new form called frmTest based on tblTest.
3. Add the following records. Note you do not need valid hyperlinks to test this:
   
   

   ID	testHyperlink
   1	123ABC456
   2	ABC123
   3	As Easy as 123
   4	ABCtestABC

4. On the Records menu, point to Filter, and then click Filter By Form.
5. Type Like "ABC*" in the testHyperlink field.
6. On the Filter menu, click Apply Filter/Sort.