Determine if field exist

[LonnieJohnson]

Is there a quicker way to determine if a field exist in a collection other than iterating through the entire collection?

I know how to do...

For Each fld in rs.Fields
If fld.Name = "MyField" Then
'do something
End if
Next fld

I want to know if you can just say

If "MyField In rs.Fields Then
'do something
End If

Thanks in advance,

ProDev, MS Access Applications
Visit me at ==>

http://www.prodev.us

May God bless you beyond your imagination!!!

 

[PHV]

A crude way:
On Error Resume Next
strName = rs("MyField").Name
If strName = "MyField" Then
'do something
End If

Hope This Helps, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ181-2886