how to check if a field name exists in recordset 3

[SweetDot]

Hi,
is there any easy way to check if a field name exists in a recordset without having to iterate through the entire list of field names?

thanks very much

 

[Veep]

I don't think so. You could though try do a Select FieldName_X from YourTable and trap for the error you're gonna get when doesn't exist.

 

[SweetDot]

icic, thanks
i think i'll just stick to iterating through the list then. might be too much trouble searching for the error trapping syntax.
thanks a lot

 

[TonyJollans]

Hi SweetDot,

It isn't really that difficult, but it does involve error trapping ..

On Error Resume Next
Set fld =

RecordSet

.Fields("

FieldName

")
On Error Goto 0

If fld is Nothing Then

    ' Field does NOT exist

Else

    ' It does

End If

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[danvlas]

Another flavour of what Tony said:

On Error Resume Next
Set fld = RecordSet.Fields("FieldName&quot
If Err.Number<>0 Then
' Field does NOT exist
Else
' It does
End If





Daniel Vlas
Systems Consultant

http://www.geocities.com/danvlas/AutoMail.html

 

[SweetDot]

thank you so much. that's much easier than i thought it would be.