Memo Field in a Text Box

  • Thread starter Thread starter Tom & Saundrah Venne
  • Start date Start date
T

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
 
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?
 
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
 
Back
Top