Memo Field in a Text Box

[Tom & Saundrah Venne]

I execute a query to populate a combo box. When the user selects one of the
entries in the combo box, four text boxes are populated from the selection.
One of the text boxes is populated from a memo type field. Needless to say,
the memo field is truncated at 256 characters. I know this is a limitation
of Access, but has anyone found a work around.

Thanks in advance

 

[Rob Oldfield]

As far as I'm aware, there's no limitation on the number of characters to
display in a textbox. I'd suspect that the problem is actually with the
code that you're using to populate the box... could you post it?

 

[Troy]

The problem is that you are using calculations on the Memo field in your
query.

The KB articles:
http://support.microsoft.com/default.aspx?scid=kb;en-us;257414

There are other newsgroup posts that state the Group By or even Distinct in
the SQL may also cause this problem with Memo data types....

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


I execute a query to populate a combo box. When the user selects one of the
entries in the combo box, four text boxes are populated from the selection.
One of the text boxes is populated from a memo type field. Needless to say,
the memo field is truncated at 256 characters. I know this is a limitation
of Access, but has anyone found a work around.

Thanks in advance