"Brendan Reynolds" anonymous at discussions dot microsoft dot com
wrote in message ...

"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)



Brendan Reynolds,

I find that to be very interesting. It's not the way I would have set
up the values of those properties in the Object Model, but oh well . .
..


Sincerely,

Chris O.