Public Function ArrayField(ByVal FirstName, ByVal LastName, ByVal Address, ByVal ZipCode) As String
Dim strField As String
strField = Space(50)
Mid(strField, 1) = Nz(FirstName)
Mid(strField, 11) = Nz(LastName)
Mid(strField, 31) = Nz(Address)
Mid(strField, 41) = Nz(ZipCode)
ArrayField = strField
End Function
Then:Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
/gustav