Some settings in MS/Access VBA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

zwasdl@gmail.com - 28 Nov 2006 13:48 GMT

In Access VBA, the immediate window only displays a couple hundred
lines of my debug output. How do I display more lines there, for
example 500 lines, or even 5000 lines? Is there a way to set the line
size in access VBA?

How do I see the complete content of a string variable while I'm
debuging without writing code to output it? The values in watch window
is truncated.

Thanks a lot!

Wei

Reply to this Message

abejer@hotmail.com - 28 Nov 2006 21:09 GMT

I have only used the immediate window to verify specific values at
given points in my program. To do this, just insert breakpoints
wherever you need them. If you really need to step into your code,
output everything to a memo field or, if needed, a text file. Another
method is to keep your visual basic window open when you run your code
in order to watch the debug sequence in the immediate window in real
time.

So far as I know, there is no way to change the settings for the
immediate window.

Alexandre Bejerman
Montreal, Canada

> In Access VBA, the immediate window only displays a couple hundred
> lines of my debug output. How do I display more lines there, for
[quoted text clipped - 8 lines]
>
> Wei

Reply to this Message

zwasdl@gmail.com - 28 Nov 2006 21:21 GMT

Thanks for your reply.

Can anyone confirm that access 2003/VBA 6.4 has such limits?
1. immediate window can only display 200 lines
2. watch window can only display first 200 characters of a value

Thanks

Wei

abe...@hotmail.com wrote:

> I have only used the immediate window to verify specific values at
> given points in my program. To do this, just insert breakpoints
[quoted text clipped - 22 lines]
> >
> > Wei

Reply to this Message

abejer@hotmail.com - 28 Nov 2006 21:35 GMT

> Can anyone confirm that access 2003/VBA 6.4 has such limits?
> 1. immediate window can only display 200 lines
> 2. watch window can only display first 200 characters of a value

These figures are about right. Still, you are complicating your life
with something that is really fairly simple. There are other ways of
trapping errors if that is what you are trying to do.

Reply to this Message

Granny Spitz - 28 Nov 2006 21:21 GMT

> How do I display more lines there, for
> example 500 lines, or even 5000 lines?

You can't. WYSIWYG.

> Is there a way to set the line
> size in access VBA?

No, it's set at 1,022 bytes. You can't change it.

> How do I see the complete content of a string variable while I'm
> debuging without writing code to output it? The values in watch window
> is truncated.

Since it's truncated, you *have* to output it somewhere like the immediate
window, a table, a message box, or a text file.

Reply to this Message

RoyVidar - 29 Nov 2006 20:42 GMT

"zwasdl@gmail.com" <zwasdl@gmail.com> wrote in message
<1164721695.102351.168820@n67g2000cwd.googlegroups.com>:

> How do I see the complete content of a string variable while I'm
> debuging without writing code to output it? The values in watch
> window is truncated.

When hovering over the variable while debugging, you'll see a certain
number of the characters from the left. If you hold CTRL when hovering,
you'll see the same number of characters from the right of the string.

If you're using the watch window, click the "Value" part for the
variable in question, then hit ctrl+c, paste it to for instance
notepad (ctrl+v)

Well, you said without programming ;-)

Signature

Roy-Vidar

Reply to this Message