Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 826
  • 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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

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