MS-Access Debug Watch value length is limited

vba ms-access ms-access-2010
Mark C picture Mark C · Oct 9, 2013 · Viewed 11.6k times · Source

I am working in MS-Access 2010 and I am trying to view a variable defined in the VBA code where it has hit a break-point. The problem in the watch window the value text box in the Watches window has a set size, in other words if the value is to long the value is cut-off in the Watches window

How can I view the whole value inside my variable?

Answer

enderland picture enderland · Oct 9, 2013

It is best to use the intermediate window for this. I frequently do this with SQL queries for this reason.

To show this, use "View--> Intermediate Window" (or Control+G).

Then use syntax like the following:

debug.print "This is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long stringThis is a really long string"

And you can select and copy/paste out of the intermediate window or scroll to see the whole variable.

Note that the intermediate window does not get cleared automatically but you can select everything and delete it whenever you want.

Related questions

How to insert values into the database table using VBA in MS access

I've started to use access recently. I am trying to insert a few rows into the database; however, I am stuck as it is throwing an error: Too few parameters. I have a table test with only one column in …

Read More
Access 2010 VBA query a table and iterate through results

I have a query that I want to execute against a table. With the results I want to do something. In my head the pseudo code is: var q = "select * from table where some condition"; var results = db.getResults(q); …

Read More
Is it possible to pass parameters programmatically in a Microsoft Access update query?

I have a query that's rather large, joining over a dozen tables, and I want to pull back records based on an id field (e.g.: between nStartID and nEndID). I created two parameters and tested them as criteria and …

Read More