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

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Rusty in Illinois (aid9401.removthis_at_nospamever.mail.idpa.state.il.us)
Date: 03/12/04 

Date: Fri, 12 Mar 2004 12:06:03 -0600

Marshall ...

Thanks for the response.

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.

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.

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 scratching my head, or I need a link to a reference on handling
CLOBs > 32K (and Module objects) in Access.

Thanks...

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).
> --
> Marsh
> MVP [MS Access]

Relevant Pages

  • Re: How to print the name of a list?
    ... no --- there is no unique mapping between references and ... reverse lookup by iterating over the global dictionary: ... for thing in baz: ... in any way except for debugging IMHO. ...
    (comp.lang.python)
  • Re: debug class library
    ... I have the Debug mode set as "Program" and Start Application set as the exe ... that references this dll. ... I tried attaching 2 screen shots, one showing the debugging settings and the ...
    (microsoft.public.dotnet.framework.compactframework)
  • BUG: debugger is case-sensitive to paths when resolving assembly refrences
    ... DotNet has always had quirky problems with debugging DLL's when running ... breakpoints (question marks), or break points that get a "plus" sign next to ... if one project references an ... treat these two references as *different* assemblies. ...
    (microsoft.public.dotnet.framework.aspnet)
  • Re: using additional form in continuous form
    ... Thank you very much, Marshall again. ... The user is Russian and is typing the text ... >>If I'm typing anything in English it's working well. ... >>> references to the wrong versions. ...
    (microsoft.public.access.formscoding)
  • Debugging Issue
    ... I start my ASP.NET application with Debugging. ... I set a breakpoint for a ... certain line that references a DataTable. ...
    (microsoft.public.dotnet.framework.aspnet)