Immediate Window has a size limitation?

[MikeB]

In the VBA IDE, does the immediate window have a size limitation?

Now that I'm getting a lot of output via the print.debug command, I
seem to lose the top of the output in the Immediate Window.

Is there an alternative command that I can use to redirect the output
to a printer or a report?

Thanks

 

[MikeB]

In the VBA IDE, does the immediate window have a size limitation?

Now that I'm getting a lot of output via the print.debug command, I
seem to lose the top of the output in the Immediate Window.

Is there an alternative command that I can use to redirect the output
to a printer or a report?

Thanks

I've been looking and I can't figure this out. It will become an
issue even more so when I actually get down to programming with VBA.

How does one create output? Is it a report? Each report that I've seen
consists of a number of controls, so I guess I can create a report
that is simply a single textarea and repeatedly writing to that?

Is that it? Doesn't seem too difficult if that is all it takes.

I'll go mess with that a little later.

 

[Clif McIrvin]

I've been looking and I can't figure this out. It will become an
issue even more so when I actually get down to programming with VBA.

How does one create output? Is it a report? Each report that I've seen
consists of a number of controls, so I guess I can create a report
that is simply a single textarea and repeatedly writing to that?

Is that it? Doesn't seem too difficult if that is all it takes.

I'll go mess with that a little later.

I've not tested this, but can't you open a printer in VBA just like in
VB6 and earlier versions?

 

[MikeB]

I've not tested this, but can't you open a printer in VBA just like in
VB6 and earlier versions?

I don't really want to print, but I've found my other Access book and
it has info on how to write to a file.

Open "out.txt" For Output as #1
Write #1 "string of text"
Close 1

I might end up doing that.

Seems to say that all strings will be in quotes, though.

But now my interest is piqued, I'm looking to see if I can find the
code to write stuff to a Report.

 

[Douglas J. Steele]

Use

Print #1 "string of text"

to get rid of the quotes in the output.

 

[david]

Yes, the immediate window has a size limitation.
I can't think of another command that is as simple as debug.print.
I normally write to a file or to a table if I have anything I wish to save.


(david)