4 Replies - 910 Views - Last Post: 03 February 2013 - 05:03 PM Rate Topic: -----

#1 lamoesma  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 26-January 13

memofield in datagrid

Posted 26 January 2013 - 04:39 PM

I am trying to populate a VB6 datagrid with a access memofield but the contents of the memofield isn't visible in tha datagrid. Does anyone has a workaround how to do this.
Thanks in advance.

Rini
Is This A Good Question/Topic? 0
  • +

Replies To: memofield in datagrid

#2 andrewsw  Icon User is online

  • It's just been revoked!
  • member icon

Reputation: 3806
  • View blog
  • Posts: 13,500
  • Joined: 12-December 12

Re: memofield in datagrid

Posted 26 January 2013 - 05:02 PM

I believe you can change the column type to Memo with something called an active grid.

Otherwise, one approach is to truncate the data in the memo field:

SELECT LEFT(Notes, 255) AS ShortNotes from SomeTable


Alternatively, you may have to include the notes outside of the grid and bind them to the current row.
Was This Post Helpful? 0
  • +
  • -

#3 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: memofield in datagrid

Posted 31 January 2013 - 11:18 PM

Datagrid can't display memo fields. Since they can be many thousands of characters, it stands to reason. Andrew's solution is a good alternative.
Was This Post Helpful? 0
  • +
  • -

#4 lamoesma  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 2
  • Joined: 26-January 13

Re: memofield in datagrid

Posted 01 February 2013 - 08:47 AM

Hi Bob and Andrew,

I followed the suggestions Andrew send to me and I succeeded in placing my memofield in my grid.
After all it wasn't such a hard job. Thanks a lot for your contributions.

Regards,

Rini
Was This Post Helpful? 0
  • +
  • -

#5 BobRodes  Icon User is offline

  • Your Friendly Local Curmudgeon
  • member icon

Reputation: 574
  • View blog
  • Posts: 2,989
  • Joined: 19-May 09

Re: memofield in datagrid

Posted 03 February 2013 - 05:03 PM

Glad you got it worked out. :)
Was This Post Helpful? 0
  • +
  • -

Page 1 of 1