I'm importing data from some word form fields. Some of the fields are blank, but I'm getting squares instead of characters for the field. When I do an ?Asc() on the squares, it says that they are # 32. I tried doing the following replace:
strName = Replace(strName, Chr(32), "", 1, 8)
This didn't work, but it did remove the spaces from other text . I also tried Chr(10) , Chr(13), vbCr, vbLF, vbCrLF, and vbTab
The replace just doesn't seem to be working on these characters.