display memo field on a form based on the value of another field

[Guest]

I want to display the contents of a memo field on a form based on the users
selection on three selections. The problem I am running into is that there
is no "row source" or "row source type" for me to put the select statement in
for a memo field in the properties section. If I change the field to a text
field, I can make it work, but I run into the 255 char limit of access. Can
anyone tell me how to accomplish this?

 

[John W. Vinson]

I want to display the contents of a memo field on a form based on the users
selection on three selections. The problem I am running into is that there
is no "row source" or "row source type" for me to put the select statement in
for a memo field in the properties section. If I change the field to a text
field, I can make it work, but I run into the 255 char limit of access. Can
anyone tell me how to accomplish this?

You can set the control source of the textbox to

=DLookUp("[memofield]", "[tablename]", "[ID]=" & [Comboboxname])

where the combo's bound column is the unique id of the record containing the
desired memo. You cannot put the content of a memo field (which, remember,
might be over a billion bytes!) into a combo box without truncating it.

John W. Vinson [MVP]

 

[Guest]

Thanks John, that did it.

I want to display the contents of a memo field on a form based on the users
selection on three selections. The problem I am running into is that there
is no "row source" or "row source type" for me to put the select statement in
for a memo field in the properties section. If I change the field to a text
field, I can make it work, but I run into the 255 char limit of access. Can
anyone tell me how to accomplish this?

You can set the control source of the textbox to

=DLookUp("[memofield]", "[tablename]", "[ID]=" & [Comboboxname])

where the combo's bound column is the unique id of the record containing the
desired memo. You cannot put the content of a memo field (which, remember,
might be over a billion bytes!) into a combo box without truncating it.

John W. Vinson [MVP]