Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 863
  • Last Modified:

VB6 sp6, MS Access ADO: Read a Memo field > 255 characters

I have an Access table called ORACLEVIEWS, and a field called "ViewTables" that is a memo - up to 1500 characters.  When I query it, ADO cuts off the memo to 255 characters.  from the immediate window, when I type ? rstmp("ViewTables") it only gives me 255 characters.  How do I get the whole memo?
sSql = "SELECT * FROM ORACLEVIEWS"
   rsTmp.Open sSql, db, adOpenStatic, adLockReadOnly  
   If Not rsTmp.EOF Then 
      If rsTmp("View") <> "" And rsTmp("ViewTables") <> "" Then
 
         Debug.Print rsTmp("ViewTables")

Open in new window

0
LovinSpoonful
Asked:
LovinSpoonful
  • 2
1 Solution
 
tbsgadiCommented:
Have a look at the following:

http://allenbrowne.com/ser-63.html


Gary
0
 
LovinSpoonfulAuthor Commented:
Thanks
0
 
tbsgadiCommented:
Glad to help
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now