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?
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. Incidentally any emails I post don't come back to me anymore so I don't know if they have been posted. Cheers Peter -----Original Message----- From: profox-boun...@leafe.com [mailto:profox-boun...@leafe.com] On Behalf Of Kent Belan Sent: 31 March 2010 14:02 To: 'ProFox Email List' Subject: RE: Memo's in grids You can use left(memofield,100) and that will display the left 100 characters of the memo > -----Original Message----- > From: profox-boun...@leafe.com > [mailto:profox-boun...@leafe.com] On Behalf Of Peter Hart > Sent: Wednesday, March 31, 2010 8:24 AM > To: ProFox Email List > Subject: Memo's in grids > > Hi folks. > > > > I have a grid which is bound to a table with memo fields for > the description and buckle columns. > > Running the form displays the word memo in the column. The > client does not like this. > > Any ideas on how I could get round the problem. > > > > T.I.A. > > > > Peter > > Peter Hart Computers > > > > > > --- StripMime Report -- processed MIME parts --- multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ 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/a57fa4cf19531343a2ee11b57db8e3af100...@server.peterhartcomputers.local ** 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.