devxlogo

Determine Whether a Field Exists in an ADODB.Recordset

Why Trust Us

Sometimes, you may need to perform conditional logic based on whether a field does or does not exist in a recordset. To check for the existence of a field, simply loop through the ADODB.Recordset Fields collection, looking for the specified field name:

Private Function FieldExistsInRS( _   ByRef rs As adodb.Recordset, _   ByVal fieldName As String)   Dim fld As adodb.Field       fieldName = UCase(fieldName)       For Each fld In rs.Fields      If UCase(fld.Name) = fieldName Then         FieldExistsInRS = True         Exit Function      End If   Next       FieldExistsInRS = FalseEnd Function

Usage:…If FieldExistsInRS(MyRecordset, “FieldName”) Then ‘ Do something if field existsElse ‘ Do something else if field doesn’t existEnd if

Charlie has over a decade of experience in website administration and technology management. As the site admin, he oversees all technical aspects of running a high-traffic online platform, ensuring optimal performance, security, and user experience.

See also  Seven Service Boundary Mistakes That Create Technical Debt
Disclosure

About Our Editorial Process

At DevX, we’re dedicated to tech entrepreneurship. Our team closely follows industry shifts, new products, AI breakthroughs, technology trends, and funding announcements. Articles undergo thorough editing to ensure accuracy and clarity, reflecting DevX’s style and supporting entrepreneurs in the tech sphere.

See our full editorial policy.

Show More