MS Access Serializing Complex SQL Fields?

It's not really complex. Basically, some data are stored as normal "Text" field but uses the built in Combo Box as Display Control. This is all fine and good except now when I try to export all the data in VBA, it's throwing 开发者_运维技巧an error everytime it reach that column because apparently it can't serialize the complex data type.

    Dim rs As DAO.Recordset
    Set rs = CurrentDb.OpenRecordset("select * from my_table", dbOpenSnapshot)
    msgbox rs(1)

Here are the field property

Try this article:

http://msdn.microsoft.com/en-us/library/bb258183(v=office.12).aspx

Multivalued fields are represented as Recordset objects in DAO. The recordset for a field is a child of the recordset for the table that contains the multivalued field...