Re: Text Box or String > 32K -- Problem?

From: Marshall Barton (marshbarton_at_wowway.com)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 13:47:53 -0600

Rusty in Illinois wrote:
>I vote for "something else going on". I've traced the code and checked
>lengths on various fields and objects while debugging the code. I've
>changed my inserts on the database to a loop of AppendChunks and it
>still seems like I'm not getting the proper data. I say that because a
>Len([MemoFieldName]) in a query and still get 32768 as the largest (and
>frequent) value. While debugging I saw a module whose Len was over
>120,000 characters.

120K characters will never fit into a text box.

>I also parse the ModuleObject.Module using a Module.Lines method to get
>individual routines out of the module. It seems as though this didn't
>make it past the 32K line because I am missing routines in my output
>tables.

What is application doing??? Some kind of source code
management control?

>Could this be an incorrect VBA library, or some other old version of
>Access97? I'm running VBA332.DLL, MSACC8.OLB, and DAO2535.tlb according
>to my References in VBA.

I'm not very good at keeping track of all these library
names and versions, but I think DAO2535 is something that
bridges an old A2 back end data mdb to an A97 front end.
This may very well be the problem, try using DAO351 (with
all service packs applied). 

-- 
Marsh
MVP [MS Access]
>Marshall Barton wrote:
>> Either you are counting incorrectly or there is something
>> else going on.  An A97 text box can hold up to 64K
>> characters.  If you only manipulate it in code, string
>> variables and Memo fields can hold over 1GB of data (but an
>> MDB file is limited to 1GB).

Relevant Pages

  • Re: I cannot reliably write the Hex number "83" to a stream
    ... ajmastrean wrote: ... transforms itself into "0x3F". ... For instance, debugging shows that ... Since you're writing text characters through an encoding object, it will in some cases encode the characters different than if you just output pure bytes to begin with. ...
    (microsoft.public.dotnet.languages.csharp)
  • Re: Why does my program change the characters in my shell
    ... > I'd like to know what the typical reason for this is. ... However, when it gets done puting the data on stdout, the program is ... > characters, just right angled shapes and stuff. ...
    (comp.unix.programmer)
  • RE: Weird TraceListener NewLine problem
    ... debugging, I think the mail message should also contain the characters. ... Steven Cheng ...
    (microsoft.public.dotnet.general)
  • TADOQuery.SQL.Text - unwanted trailing characters
    ... I have a TADOQuery object and am trying to set the SQL.Text property. ... When debugging the ADOQueryUpdate.SQL.Text has some unwanted trailing ... characters: 'update TABLE set COLUMN = VALUE where COLUMN = ...
    (borland.public.delphi.database.ado)