Maximum Length of Query String is 512 Characters?

[Stuart E. Wugalter]

Hello:

I have a form (record source: tblMasterTable) containing a MEMO
field named "FASTA." I have used a double-click event to trigger a macro
that runs the following query:

SELECT SNPID, OrderNum, RefNo, FASTA
FROM tblMasterTable
WHERE Forms!frmFASTA!FASTA=FASTA;

I can double-click on a record's FASTA field (in form view) and a table view
will show
me that same record and any other records with matching FASTA fields.

My problem is that the query will not work for FASTA fields which are larger
than 512 characters. Can anyone help me with this? TIA, Stuart

Stuart E. Wugalter
Statistician II
Building: PMB B100
Mail Code: 9011
Department: Zilkha Neurogenetic Institute
Division: Keck School of Medicine
University of Southern Californa
Telephone: [phone]
FAX: [phone]
E-Mail: wu******@usc.edu