Looking up a Memo field

[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?

 

[Allen Browne]

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