recordset - checking field contents 2

[rossmcl]

what is the syntax for checking the contents of a field in a recordset in a particular column?<br><br>something like rs.column.fieldcontents?<br><br>Does checking every field slow things down dramatically (less than 30 records, 5 columns) or should I set it up to only check the column in question?<br><br>Thanks<br><br>Ross<br><br>Also, is there a good online source of all the properties etc.?<br><br>

 

[marshalsea]

I think what you're after is:<br>(where rst is a recordset object)<br><br>rst.field(&quot;&lt;Fieldname&gt;&quot<br><br>Speed is probably negligable, as long as you're not retrieving Notes/Memo fields.<br><br>As for reference, MSDN it...<br>Although it's tricky to navigate it's all in there.<br><br>Otherwise any VB6 book with a Database section of ADO (I think) should be able to help you.<br><br> <p>Ben Marshalsea<br><a href=mailto: > </a><br><a href= > </a><br>