Memo fields

T

tezza

Hi,
I have created a table from some data exported from another application.
One of the fields on my table holds a description greater than 256 chars so
I have made it a memo field.
When I use Search by Form on this field I do not always get the correct
results.
If I look at the underlying ascii data, lets say in Notepad, I can find what
I am looking for.
If I use Search by Form on the memo field in my table, I do not get the same
results.
Anybody got any clues?
The memo field is a concatenation of 15, 55 character descriptions and
contains lots of space characters.
 
S

Sheila D

Cn you be a bit more specific, is it ascii characters you are looking for or
normal text?

Sheila
 
T

tezza

Hi Sheila,
I'm searching for normal text.
Sorry if I confused you with the ascii bit.
The original data was exported as ascii from another application and I have
imported it into a table.
 
J

John Vinson

Hi,
I have created a table from some data exported from another application.
One of the fields on my table holds a description greater than 256 chars so
I have made it a memo field.
When I use Search by Form on this field I do not always get the correct
results.
If I look at the underlying ascii data, lets say in Notepad, I can find what
I am looking for.
If I use Search by Form on the memo field in my table, I do not get the same
results.
Anybody got any clues?
The memo field is a concatenation of 15, 55 character descriptions and
contains lots of space characters.

If Search by Form fails for you (as Joseph suggests), you can use the
form's Filter property instead; set the filter to

[Memofield] LIKE "*the text to search*"

Is there any way you could import these 15 descriptions into fifteen
*records* in a related description table? Might make searching easier!

John W. Vinson[MVP]
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top