John W. Colby
jwcolby at colbyconsulting.com
Tue Mar 23 14:07:44 CST 2004
I currently determine the data type of the data that a control is displaying by the following code: Dim strCtlSrc As String Dim rst As DAO.Recordset Dim intType As Integer strCtlSrc = txtDOB.ControlSource Set rst = Me.RecordsetClone intType = rst.Fields(strCtlSrc).Type Is there a similar method of getting at this from ADO? John W. Colby www.ColbyConsulting.com