I'm trying to set the UniCodeCompression property programmatically and getting an error.
I need to do this to about 50 fields in 370 tables, so I'm trying to modify code that I already use to set the field size and required property, but for some reason the code below fails when it hits the statement that tries to set unicodecompression on.
Set fld = TD.CreateField("temp", dbText, fldSize)
TD.Fields("temp").AllowZeroLength = logAllowZero
TD.Fields("temp").DefaultValue = strDefaultText
TD.Fields("temp").Required = logRequired
TD.Fields("temp").UnicodeCompression = True
Let me know if you need too see the entire module. I"m stuck using a mac today and can't even find notepad!