Word wrap of a memo field in a list box

[Dclegg]

I have a complex form that contains several list boxes based on several different queries from 6 different tables. The user inputs a case file number and through table relationships and table joins, information from the tables is inserted into various sections of the report. The queries all work and return all of the information needed to complete the form.

The problem is that one database field is a memo field (I can't change that) and is (or maybe) longer that the page is wide and the data won't wrap and is cut off. The box is set so it can grow, but by default has room for 6 lines and is 7.5 inches wide.

I have changed the list box to a text box, which wraps the long memo line, but displays only the first record. Second and subsequent records are not displayed.

I need to be able to display all of the records and all of the text associated with them on the form. The query works fine. In the database view of the query, all records are returned correctly so I know it is working.

Need help with how to get the info to display correctly.
[sig][/sig]

 

[DougP]

What about putting a sub-report in place of the Text box.
And have the Child/Master link a unique criteria that will bring back all of the records you need. Make the Link field invisible or very small so it won't show. Have the memo field go in a text box, but becasue it's in a subreport it should show all of the records.

[sig]<p>DougP, MCP<br><a href=mailto: dposton@universal1.com> dposton@universal1.com</a><br><a href= > </a><br> Ask me how Bar-codes can help you be more productive.[/sig]

 

[Dclegg]

Thanks for the info. I created a subform and it displays all of the records but data is truncated and I can't change the font size. Moved the subform to the bottom of the form, made it invisible, and built a text box using the subform as the source. The text box only shows the first record. Back to where I was before the subform. Thoughts? [sig][/sig]