Programmatically set Unicode Compression

[Ronald]

Hi all.

I can create tables with fields and set field Required to Yes and so on. (wow)
The Text fields are default with Unicode Compression set to No and I cannot
find the command to change it.
Can any MVP help me please?
Thank you.

Ronald.

 

[John Spencer]

Hint:

Currentdb().TableDefs("Faq0").Fields("fSubject").Properties("UniCodeCompression")
= True

It may be
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County

 

[Ronald]

Thank you very much, John.

Hint:

Currentdb().TableDefs("Faq0").Fields("fSubject").Properties("UniCodeCompression")
= True

It may be
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County