how to change field properties with rules

Question

I'm trying to make a rule that will change field properties (required, read only) and can't figure out how the correct usage. Any pointers? 
 it will eventually be part of if statements but for now... 
 I get ActiveX automation object var is Nothing 
 Sub main Dim depth As Field depth.Required = True End Sub

Phil Wade · Answer

Hi Brett 
 These are DAO field properties, you loop through the properties for a field until you find the relevant one, and set the value. 
 docs.microsoft.com/.../field-object-dao 
 regards 
 Phil Wade

Phil Wade · Answer

For SQL Server, the field properties are stored in SQL Server db table WH_ColumnProperties. You can read and write using SQL select and update statements.