Getting whole value from a string variable

[Always_Learning]

Hi There,

I am trying to find an error in my code.
I have added the variable to the watch list but I cannot copy the whole value from the watch list.
How can I get the full value of the string variable?

Thanks for your help.

Best Regards,



Steve

[JoeM]

Exactly how long is the string value?
How about if you use a MsgBox?

[ItsMe]

If the variable appears in the Watch List as having a value, it is in scope and should be available in the Immediate Window at that time (When it is in the Call Stack). So, you should be able to determine the value of a variable that is in scope by typing ? and the variable name in the Immediate window, then hit the Enter key on your keyboard.
?strMyVariable

[Always_Learning]

Hi There,

Using the immediate window worked for me.

Thanks for your quick reply.

Best Regards,

Steve.

[Always_Learning]

Hi Joe,

Thanks for the reply.
I have got this working now.
My string was holding a select statement that I could not see fully.

Best Regards,

Steve.