Clear Intermediate Window

  • Thread starter Thread starter Ross
  • Start date Start date
R

Ross

To All,

How can I erase the display contents of the intermdiate window using VBA?

Is there a way?

Thank you

Ross
 
The only way I'm aware of is to send a whole bunch of blanks to it, but off
the top of my head, I don't remember what the capacity of the window is.
Assuming it's 2000 characters (I'm sure it's higher), you can do

Debug.Print Space(2000)

I'm hard-pressed to think of a reason why you'd need to do this though!
 
Doug,

Thank you!
I do a lot of debuging by runing and re-running code 'til it works. This
will give me a "Gap" to see where one "run" ends and another one begins.

Thanks again.
 
VBE.Windows("Exécution").SetFocus
SendKeys "^{HOME}^+{END}{DELETE}"


where it is left to you to find the window name in English.

(from an original reply from 3stone)



Vanderghast, Access MVP
 
vanderghast said:
VBE.Windows("Exécution").SetFocus
SendKeys "^{HOME}^+{END}{DELETE}"


where it is left to you to find the window name in English.

(from an original reply from 3stone)



Vanderghast, Access MVP
Click to expand...

SendKeys "^a{DELETE}"

will do it too.
 
Back
Top