[AccessD] Search Memo field for number string

Sheri,

I can't help with the Bold part...but on the search...I'm guessing you are 
looking at a phone number...or some other 2 part number sequence...either 
way...you can seperate your number into two pieces of criteria ( 2 fields on 
a form )...and the place something like:
Like "*" & [Forms]![frmTest1]![NumPart1] & "*" & 
[Forms]![frmTest1]![NumPart2] & "*"

in the MemoField Criteria or your query.  The problem with this...is that 
the query doesn't care if there is 1 or 1000 characters between the 
numbers...it still returns the records.

Hope it gives some direction.

Thanks,

Mark A. Matte
>From: "Sheri Hixson" <sdhi at kalamazoo.net>
>Reply-To: Access Developers discussion and problem 
>solving<accessd at databaseadvisors.com>
>To: <accessD at databaseadvisors.com>
>Subject: [AccessD] Search Memo field for number string
>Date: Mon, 31 Oct 2005 10:36:08 -0500
>
>I need to search a memo field for any string of any numbers sequenced as
>follows,  ### #### or ###.#### or ###-#### or ####### . I also want to bold 
>the
>number sequence found in each memo field. Anyone have any ideas on how to 
>setup
>this query? Thanks for any help!
>
>
>
>Sheri
>
>--
>AccessD mailing list
>AccessD at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/accessd
>Website: http://www.databaseadvisors.com