Immediate Window 2

[tech12345]

This is probably a basic question, but I see a lot of code examples using Debug.print to copy some information to the Immediate Window
eg
Debug.Print Formname
Debug.Print (strMsgPrompt)

I can see the value of this for checking small amounts of information, but what about larger amounts.

I know you can use extra code to populate fields (for example) but It is used such a lot in code as simply Debug.Print. I wondered if there was a way of using the information straight from the Immediate Window itself, which I haven’t caught on to yet.

Any observations/suggestions would be gratefully received

 

[Tranman]

You can interrogate a field, property; etc. by just typing a question mark and the field/object name:

?rs.fields("MY_FIELD&quot

?con.Provider

and hitting enter.

This is a good technique to use if you need to look at a long string or something, and don't want to put print statements in your code.

You can also set properties on the fly, which is handy sometimes.

Tranman

 

[markgrizzle]

Also great for long sql strings, which you can then cut/paste into the query builder's sql window.

 

[tech12345]

Thanks for the help, Its confirmed that my understanding was on the right lines. I suppose the name Immediate is very appropriate.