View Single Post
  #6  
Old March 3rd, 2005, 08:55 PM
Brendan Reynolds
external usenet poster
 
Posts: n/a
Default


"Chris2" wrote in message
...
snip
Does an empty ADO recordset really display *both* BOF and EOF at the
same time?


Yes.

Public Sub BofAndEof()

Dim rst As ADODB.Recordset
Set rst = New ADODB.Recordset
With rst
.ActiveConnection = CurrentProject.Connection
.Source = "SELECT * FROM Categories WHERE False"
.Open
Debug.Print "BOF: " & .BOF
Debug.Print "EOF: " & .EOF
.Close
End With

End Sub

In the Immediate window ...

bofandeof
BOF: True
EOF: True

--
Brendan Reynolds (MVP)