Trouble with long text

[lefty2cox]

I have a form based on a table. The table has a long text field, which is the control for a text box on the form. But the text is getting cut off. Looks like the long text is exceeding the limit of the text box on the form.



Is there a "memo" or long text control that can be put on a form to display long text from a table? If so, I can't find it.

Thanks.

[Micron]

There is only textbox, not 'long text' textbox. Are you sure the full text is in the table field? By 'cut off' you mean truncated or all the text is there in the form control but you can't see it all at once?

[ranman256]

if you make the text box bigger (with bound memo fld) then it should show all the data.

[Gicu]

Shouldn't be cut off unless the form's record source is not the table itself but a query with Group BY or Distinct.

Cheers,

[Micron]

Shouldn't be cut off unless the form's record source is not the table itself

Unless the data was truncated by an import/transfer. Let's see if it's actually there first?

[lefty2cox]

Shouldn't be cut off unless the form's record source is not the table itself but a query with Group BY or Distinct.

Cheers,

This appears to be the case. The table field is long text but the form is coming from a query with "group by". I eliminated the group by... I wasn't using it for any purpose, just must have set it when I was figuring this out. Now all of the text is displayed. Thank you very much and thank you to everyone for the suggestions.

[Gicu]

Glad to hear you solved it, good luck with your project!

Stay safe!

[Micron]

I have a form based on a table

Glad you solved it with Gicu's excellent insight, but that statement was kind of misleading

[isladogs]

See this article by Allen Browne for a list of all the reasons causing long text fields to be truncated at 255 characters: http://allenbrowne.com/ser-63.html