Jan 14 2012, 02:41 AM
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.
Jan 14 2012, 01:50 PM
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?
Jan 17 2012, 11:48 AM
Yes I'm using a query that includes the MEMO field.
Jan 18 2012, 12:14 AM
Jan 18 2012, 10:31 AM
Thanks HiTechCoach, Appreciate your effort in helping me. Owe you one.
Jan 19 2012, 12:04 AM
Did you get your issue resolved?
Jan 21 2012, 11:10 AM
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.
Jan 22 2012, 02:42 PM
Thanks for the update and your solution.
Good luck with your project.
This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here