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