MEMO Field cut off on Form

[BlueWolverine]

Hello,

MS ACCESS 2003 on XP Pro.

I have a form trying to display a memo field which really only ever stores
text (strings if you will).

The form cuts the data off at 255 characters despite the fact that the memo
has way more than that stored in the table ( and thus the reason for the memo
field.)

What can I do to get the form to display the entire memo field?

Thanks.

 

[BlueWolverine]

I found the answer!

GROUP BY and SELECT DISTINCT queries will truncate the value of a memo field
down to a text field (ie 10000 characters to 255). So the form was based on
a group by query and thus was truncated. Once I worked around that I was
fine. The only problem will be if I ever NEEDED to have a groupby and
display the contents. Although maybe I could perform the group by and then
join to the memo field.

 

[Pravin Bhoite]

I found the answer!

GROUP BY and SELECT DISTINCT queries will truncate the value of a memo field
down to a text field (ie 10000 characters to 255).  So the form was based on
a group by query and thus was truncated.  Once I worked around that I was
fine.  The only problem will be if I ever NEEDED to have a groupby and
display the contents.  Although maybe I could perform the group by and then
join to the memo field.  

Hi There,

I am facing same problem. How did you display data from query into
text box. I mean what is controlsource property for text box ? My
query is fetching the correct value but I am not able to display it in
textbox. I tried combo and list box but it truncates the data.

Thanks,

Pravin

 

[John W. Vinson]

I am facing same problem. How did you display data from query into
text box. I mean what is controlsource property for text box ? My
query is fetching the correct value but I am not able to display it in
textbox. I tried combo and list box but it truncates the data.

Base your Form on the query, put a textbox on the form, and set its Control
Source property to the name of the memo field. Textboxes don't truncate
(unless you specify a Format property for the textbox); listboxes and combo
boxes do truncate.