Access text box truncating memo field

A listbox is not designed to display "Memo" data.
1. Can you explain what your are trying to accomplish here?
2. Can the field be converted to "text"

still not sure why you are using a control designed to display "one" value, to display memo data...?

Create a form to display the memo field from the MyDB table.

Make it a subform in your main form with the ListView.

Create a master child link between the form and subform using the ListView as the master I(assuming its value is the KeyField), and the child link field as the KeyField from the MyDB table.

The subform should refresh when the list view selection changes.

What I wanted was to click a row in a list box and show all text in the memo field in a square box on the form (as the memo data is easier to read in a square box instead of a long line)
Thanks all for the help