Showing full texts & avoid concatenation (1 Viewer)

use a form to display your memo.

Previously, due to formatting, the field was truncated at 255 characters.
Now all text is being imported but is too large to fit in the space available.
On your form, you can increase the width of the listbox column holding that field but because its a listbox you can't show the text on multiple lines. However you do see the full text in the textbox below the list.

You shouldn't be viewing data directly in the table but if you really want to do this you can increase the row height to show all the text.

Thank you all for your time and support.
Inspired by your ideas, i saw that the text is truncated in the query first. When i creat a form based on a tbl it doesnt truncate the text.
Is it possible to reflect the full text in the qry result?

Jakmalan said:

Thank you all for your time and support.
Inspired by your ideas, i saw that the text is truncated in the query first. When i creat a form based on a tbl it doesnt truncate the text.
Is it possible to reflect the full text in the qry result?

Click to expand...

Hi. In post #7, Colin gave you a link showing some reasons why a memo field might get truncated in a query. Is your query doing anything in that list? If not, then yes, it should be possible to use a query on your form rather than a table.