https://forums.autodesk.com/t5/vba-forum/ado-unique-values-field/m-p/1727181#M32054 Caddie,<BR /> <BR /> With ADO 2.8 you can check to see if your Attributes property exposes the adFldIsNullable enum. If so then you'll know the Field accepts null values.<BR /> <BR /> G'Luck <BR /> <BR /> Bob Coward Mon, 07 Aug 2006 17:30:17 GMT Anonymous 2006-08-07T17:30:17Z https://forums.autodesk.com/t5/vba-forum/ado-unique-values-field/m-p/1727180#M32053 Hi there all,<BR /> <BR /> Does anyone know how to identify if a ADO recordset field has the property "no duplicates allowed"? (or which combination of properties)<BR /> <BR /> I Use the reference activex data objects 2.8 library, with Autocad 2006/2007 and I read the recordset from a MS Access database.<BR /> <BR /> Any help/advise?<BR /> <BR /> A Caddie. Sat, 05 Aug 2006 10:28:53 GMT https://forums.autodesk.com/t5/vba-forum/ado-unique-values-field/m-p/1727180#M32053 Anonymous 2006-08-05T10:28:53Z https://forums.autodesk.com/t5/vba-forum/ado-unique-values-field/m-p/1727181#M32054 Caddie,<BR /> <BR /> With ADO 2.8 you can check to see if your Attributes property exposes the adFldIsNullable enum. If so then you'll know the Field accepts null values.<BR /> <BR /> G'Luck <BR /> <BR /> Bob Coward Mon, 07 Aug 2006 17:30:17 GMT https://forums.autodesk.com/t5/vba-forum/ado-unique-values-field/m-p/1727181#M32054 Anonymous 2006-08-07T17:30:17Z