Hi,

I am using a ADODB recordset which is connected to a database in SQL server. And I am trying to use the !(bang) operator to access a field value from a recordset. But it is giving a error. ie. Following usage gives a error.

rs!fieldname

But if I replace it with

rs.Fields("fieldname").value

notation it works. I thought both were interchangeable.

Can somebody help me to understand why this problem is occurring?

Bye,
Sundar