Minty:
Just to clarify... are you recommending unicode compression to FALSE (opposite of "But NOT when the fields have unicode compression turned on.")?
Code:
For Each fld In flds
If fld.Type = dbText Then
fld.Properties("UnicodeCompression").Value = False
'SQLString = SQLString & "[" & fld.Name & "] = Trim([" & fld.Name & "]),"
SQLString = SQLString & "[" & fld.Name & "] = Left([" & fld.Name & "],InStr(1,[" & fld.Name & "],' ')),"
End If
Next fld
If so, that throws an error "Property not found."
Also, all fields are data type = "Short Text" (vs. "Long Text"). Not clear on what should change?