New Topic/Question
Reply
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
4 Replies - 380 Views - Last Post: 03 February 2013 - 05:03 PM
Rate Topic:
MultiQuoteReplies To: memofield in datagrid
#2
andrewsw
- Provides a RESTful service
-
Reputation: 1053
- Posts: 3,313
- 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:
Alternatively, you may have to include the notes outside of the grid and bind them to the current row.
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
- Your Friendly Local Curmudgeon
-
Reputation: 545
- Posts: 2,901
- 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
- New D.I.C Head
Reputation: 0
- 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
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
Page 1 of 1
|
|
| 