View variable values

[john]

Is it possible, for learning purposes, to show the values of an array?
Something like:
arMyArray.view()?

I tried MsgBox (arMyArray) but that (obviously) doesn't work.
Thanks,
john

[Rich P]

Think of an Array as a list with sequential indexes - starting at 0.

Dim arr(2) As String
arr(0) = "a"
arr(1) = "b"
arr2() = "c"

You have to loop through the array to get the values that are stored in
the array:

Dim i As Integer, str1 As String
For i = 0 to Ubound(arr)
str1 = str1 & arr(i) & ", "
Next
MsgBox str1

Now the MsgBox will display all the values in arr.

Note: Ubound is a built-in function that gets the upper value of an
array. I could have just said
For i = 0 to 2

But it is good practice to use Ubound for when you use dynamic arrays
where you don't really know the upper value ahead of time. For dynamic
arrays you increment them using
Redim Preserve. This is all in the help files.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Smartin]

john wrote:

Is it possible, for learning purposes, to show the values of an array?
Something like:
arMyArray.view()?

I tried MsgBox (arMyArray) but that (obviously) doesn't work.
Thanks,
john

In addition to what Rich P explained, you could also set a break point
in your code, then select View|Locals to see the contents of your array
(as well as other variables and such).
--
Smartin

[john]

Thanks,
Sometimes it's hard to find another app's functionality equivalent in
access. In Paradox ar.view() shows the contents of the array in a little
srollable form.
john

<<It's easy to find your socks if you know in which drawer they are ;-)>>

"Rich P" <rp*****@aol.comschreef in bericht
news:45***********************@news.qwest.net...

Think of an Array as a list with sequential indexes - starting at 0.

Dim arr(2) As String
arr(0) = "a"
arr(1) = "b"
arr2() = "c"

You have to loop through the array to get the values that are stored in
the array:

Dim i As Integer, str1 As String
For i = 0 to Ubound(arr)
str1 = str1 & arr(i) & ", "
Next
MsgBox str1

Now the MsgBox will display all the values in arr.

Note: Ubound is a built-in function that gets the upper value of an
array. I could have just said
For i = 0 to 2

But it is good practice to use Ubound for when you use dynamic arrays
where you don't really know the upper value ahead of time. For dynamic
arrays you increment them using
Redim Preserve. This is all in the help files.

Rich

*** Sent via Developersdex http://www.developersdex.com ***

[Tom van Stiphout]

On Fri, 15 Sep 2006 07:29:00 +0200, "john" <jo**@test.comwrote:

Nothing built in, but nothing stops you from writing your own function
that takes an array and writes it to a MsgBox or the Debug window.

-Tom.

>Thanks,
Sometimes it's hard to find another app's functionality equivalent in
access. In Paradox ar.view() shows the contents of the array in a little
srollable form.
john

<<It's easy to find your socks if you know in which drawer they are ;-)>>

"Rich P" <rp*****@aol.comschreef in bericht
news:45***********************@news.qwest.net.. .

>Think of an Array as a list with sequential indexes - starting at 0.

Dim arr(2) As String
arr(0) = "a"
arr(1) = "b"
arr2() = "c"

You have to loop through the array to get the values that are stored in
the array:

Dim i As Integer, str1 As String
For i = 0 to Ubound(arr)
str1 = str1 & arr(i) & ", "
Next
MsgBox str1

Now the MsgBox will display all the values in arr.

Note: Ubound is a built-in function that gets the upper value of an
array. I could have just said
For i = 0 to 2

But it is good practice to use Ubound for when you use dynamic arrays
where you don't really know the upper value ahead of time. For dynamic
arrays you increment them using
Redim Preserve. This is all in the help files.

Rich

*** Sent via Developersdex http://www.developersdex.com ***