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?

On Wed, 13 Jun 2007 11:29:03 -0700, Jerry in the Desert. <Jerry in the
Desert.@discussions.microsoft.com> wrote:

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

Thanks John, that did it.

"John W. Vinson" wrote:

> On Wed, 13 Jun 2007 11:29:03 -0700, Jerry in the Desert. <Jerry in the
> Desert.@discussions.microsoft.com> wrote:
>
> >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]
>