asked on Declare string array in one line
Hi
I am trying to make this work in Microsoft Access 2013. (see below.)
I would like declare a defined array very much like the second line of the code.
Thank you.
I am trying to make this work in Microsoft Access 2013. (see below.)
I would like declare a defined array very much like the second line of the code.
Thank you.
Dim fileNameArray() As String
fileNameArray = Array("a", "b", "c", "d", "e")
Microsoft Access
Last Comment
Dale Fye
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Both answers were correct, but you NAILED it Mr Fye.
I wasn't aware of the split function. Perfect!
Thank you
I wasn't aware of the split function. Perfect!
Thank you
glad I could help.
that's not possible as the Array function only produces variant arrays. That gives you the possibility to create mixed datatype arrays but for the price that you can't create string arrays with this function. So your code works with this if you can live with using variants:
Open in new window
Cheers,
Christian