Peter Hart wrote: > Hi Allen and Kent > > Edit box works. Only shows "memo" with sparse set true. Unfortunately > the edit box only show the top half of the words in the 1st line. Maybe > if I have a look at alignment?
Also get rid of the border (set border to 0 = None). > > Were would I put the left(memofield,100) code? > At the moment the columns aren't bound to the table. So nothing in the > control sources. I created a field in the SELECT SQL that I use to hold the first 'n' characters of the memo field. -- Mike Babcock, MCP MB Software Solutions, LLC President, Chief Software Architect http://mbsoftwaresolutions.com http://fabmate.com http://twitter.com/mbabcock16 _______________________________________________ Post Messages to: ProFox@leafe.com Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/4bb37021.2030...@mbsoftwaresolutions.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.