Setting 'Allow Multiple Values' of column from VBA RRS feed

  • Question

  • Hi All,

    I have a frontend in Access that connects to Access tables as backend via linked table.

    Requirement is to convert an existing field that has Dosplay Control as 'Text' to'List Box', to set row source and to set 'Allow Multiple Values' to Yes.

    I have managed to set 1st two properties of the column but not able to set the 3rd one.

    The 1st two is getting set in the following manner :

     varOldValue = obj.Properties(strName)
      obj.Properties(strName) = varValue
      adhSetProp = varOldValue

    For setting Display Control, I passed strName=DisplayControl and varValue=110

    For setting Row Source, I passed strName=RowSource and varValue=<tableName>

    What should I pass as name for 'Allow Multiple Values' and what new value ...



    Varun Sharma
    Monday, July 18, 2011 4:59 AM