Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Word wrap of a memo field in a list box

Word wrap of a memo field in a list box

Word wrap of a memo field in a list box

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.  

RE: Word wrap of a memo field in a list box

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.

DougP, MCP

Ask me how Bar-codes can help you be more productive.

RE: Word wrap of a memo field in a list box

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?

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close