Looking up a Memo field

  • Thread starter Thread starter Sitara Lal
  • Start date Start date
S

Sitara Lal

I understand that Acces 2003 cannot look up the contents of a memo field in
a related table. How else can I resolve this problem:

I have a product table which contains product details that exceed 255
characters, hence necessitating a memo field.

I need to have other tables automatically load the value of Product_Details
as a lookup function.

How can I do that?
 
Not sure where you got that information from.

A query will return the contents of the memo field unless you ask Access to
aggegate on the memo.

Alternatively, DLookup() will lookup the field. If you are not sure how to
do that, see:
Getting a value from a table: DLookup()
at:
http://members.iinet.net.au/~allenbrowne/casu-07.html
 
You must log in or register to reply here.

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

Similar Threads

Memo type field size 7
Query in vb.net not returning all characters in access memo field 1
Write to a Memo Field 1
Strange Asian looking characters in output 3
Memo Field in Table Truncated in query results and in report 1
Memo Field Text Hidden 2
ADO help : 255 Character limit on memo field....!??!?!? 4
Memo Field - Won't allow type 4

Back
Top