[SOLVED] What do the abbreviations for the BOF and EOF properties mean (stand for) in MS Access VBA code?

What do the abbreviations for the BOF and EOF properties mean (stand for) in MS Access VBA code?

End-of/Beginning-of file/field? I understand what these properties are used for but want to confirm what the letters stand for. Tried looking up but everyone, including Microsoft, is explaining what the functions do but no one has spelled out the name.

Solution

the term "EOF" was actually quite common in our industry at one time.

think of punched cards, or even reading a file. You are done when you "reach end of file".

However, context here matters. We are not reading a file, but in context of a data table? Well, the term is still used.

Given that ms-access is more then 25 years old (a quarter of a century), then common terms back then in our industry are not all that common today.

So, then this:

Sub FunTest22()

    Dim rstHotels       As DAO.Recordset
    Dim strSQL          As String
    
    
    strSQL = "SELECT ID, HotelName FROM tblHotelsA ORDER BY HotelName"
    
    Set rstHotels = CurrentDb.OpenRecordset(strSQL)
    
    Do While rstHotels.EOF = False
        Debug.Print "id = " & rstHotels!ID, "Hotel Name = " & rstHotels!HotelName
        
        rstHotels.MoveNext    ' move to next row in record set
    Loop
    
    rstHotels.Close
    

End Sub

output in immediate window:

id = 78       Hotel Name = Athabasca Hotel
id = 73       Hotel Name = Banff Aspen Lodge
id = 95       Hotel Name = Best Western
id = 349      Hotel Name = Four Seasons Motor
id = 9        Hotel Name = Four Seasons Motor
id = 10       Hotel Name = Heritage Inn of the South
id = 68       Hotel Name = Holiday Inn Express

So, the typical "use" of EOF (end of file) is as per above.