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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jerry in the Desert. - 13 Jun 2007 19:29 GMT

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?

Reply to this Message

John W. Vinson - 14 Jun 2007 02:13 GMT

>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]

Reply to this Message

Jerry in the Desert. - 14 Jun 2007 15:35 GMT

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
[quoted text clipped - 12 lines]
>
> John W. Vinson [MVP]

Reply to this Message