Re: Access 'there isnt enough memory' when scrolling textbox

There is a 64KB limit when the user interaction with the control is
required. This is an old GDI WIndows limitation linked to the 64KB limit of
the ScrollBar control.

Other than cutting your data up into manageable chunks, you could use the
RTF control on my site that you mentioned failed. You just have to set the
MaxCharsAllowed property in the Load event of the form containing the
control. I think I maxed this value out at 1000KB.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.


"robert.waters" <robert.waters@xxxxxxxxx> wrote in message
news:3e91475b-0114-49fb-a189-cdae85317356@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
I have an Access database frontend linked via ODBC to a large
(gigabytes) mysql database.
I need to view a large amount of data in a a textbox (variable up to
300K), but I receive a 'there isnt enough memory' error whenever I
scroll past N number of bytes in a textbox that has been filled with a
lot of data. I am not sure what N is, but for a large chunk of data
it occurs at about the halfway scroll, and smaller chunks might not
throw the error until scrolling to the very end.

Now, this isn't an issue with system memory; I have 3GBs of RAM in
this machine, and plenty of fast (RAID0) pagefile access. The Access
application does not consume any more memory when the textbox is
scrolled than it did when the textbox was first filled (verified with
sysinternals procexp). It seems like Access is hitting a wall
somewhere.

Is there another textbox-like control that will accept more data? I
have tried Mr. Lebans' rich text box, but was not successful.
Has anyone tried working with large datasets and had a similar
problem? Any solutions?

Thanks in advance,
Robert Waters


.

Relevant Pages

  • Re: How to scroll to text box when keyboard is displayed
    ... control is in the right place. ... the input panel ... desktop (Tab to the next one, use the Down arrow to scroll). ... When the input panel is enabled and there is a textbox that has focus ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: I need a text box that will both scroll and lock.
    ... I need a control that will let me display about 20 lines of text ... The Locked property works but the scroll bar does not appear unless ... Microsoft Forms 2.0 TextBox ... Any ideas for how to get one of these to both lock and show the scroll ...
    (microsoft.public.access.forms)
  • Re: Need to use VBA to put image on a form
    ... Earl Kiosterud ... the OP can place an Image control, ... this way the form's native ScrollBars can be used to scroll the contents of the Image ... Note: Some folks prefer bottom-posting. ...
    (microsoft.public.access.formscoding)
  • Re: need a control for good scrolling status output
    ... A regular textbox control would work perfectly fine for me if only as I ... visible and older info can scroll off the top of the textbox. ...
    (microsoft.public.dotnet.framework.windowsforms.controls)
  • Re: How do you interactively write to a CEditView Window
    ... When you scroll the ... the window flashes a lot. ... and trying to control the flashing and deal with the user resetting ... note that sizeof() a string will include the NUL character, while what you really want is ...
    (microsoft.public.vc.mfc)