[AccessD] The ARRAY function

Jim Lawrence (AccessD) accessd at shaw.ca
Wed Dec 17 19:28:27 CST 2003


Hi All:

I am running in some strange responses, maybe too much chocolate has fuddled
the brain but:

Given the following:
' Set strStuff
strStuff = chr(34) & "Tom" & chr(34) & ", " & chr(34) & "Dick" & chr(34) &
", " & chr(34) & "Harry" & chr(34)
' Print strStuff
? strStuff
"Tom", "Dick", "Harry"
' Run the ARRAY function to place the contents of the string into an array.
varArray = Array(strStuff)
? varArray(0)
' Print the first index.
"Tom", "Dick", "Harry"
' OK ?????
' Now type in the same information manually or cut and paste...
varArray = Array("Tom", "Dick", "Harry")
? varArray(0)
' and the results are what they should be.
Tom

What is going on and why can a variable not be used in the ARRAY function??
:-(

Any suggestions would be greatly appreciated.
Jim



More information about the AccessD mailing list