Hi, I've a text box in my Order Entry [table type - MEMO] which records the Item Description. At times user enter about 20 lines into this box by using Shift F2. It is okay in the form, but when send to print half of the lines do not appear, around 8 lines are printed out.. strange but true. I've set "Can Grow / Can Shrink" to YES, still this error appears. I am using a dot matrix printer to print. What must I do more to correct this? Any help is much appreciated.

Sounds like the memo field is getting truncated to 255 character

Are using a query with Distinct and/or grouping that includes the Memo field?

Yes I'm using a query that includes the MEMO field.

see Truncation of Memo fields

Thanks HiTechCoach, Appreciate your effort in helping me. Owe you one.

You're welcome.

Did you get your issue resolved?

Hi Boyd, Yes I got it right by inserting "first" instead of "Group By". I really do not know how to manage the DB without you guys. Thanks guys.

Thanks for the update and your solution.

Good luck with your project.