Solved Convert AD Property from Array to String in Access VBA

[pooldead]

I am getting a "Type Mismatch" error when I use Access VBA to pull the "description" field from an Active Directory group. I've done research and figured out this is because the "description" field is viewed as an array. Is there a function or tool I can use to convert this from an array to string?

 

[pooldead]

I figured this out. Using the JOIN() function against the "description" field converts it to a string that is readable.

 

[Cronk]

One dimensional array?

for i = 0 to ubound(yourArrayVariable) -1
   yourString = yourString & " " & yourArrayVariable(i)
next