If you mean when looking at the list of tables in the database window, there
is no built-in feature to do this. There are various programmatic ways that
you could display that information. Here's an example of one method that
would be suitable for a database that contained a modest number of local
tables. You'd need to modify this example though if the database contained a
large number of tables, or contained any linked tables.
This example will display a list of non-system tables and their record count
in a list box when the user clicks a command button. In this example
'cmdTest' is the name of the command button, and 'lstTest' is the name of
the list box.
Private Sub cmdTest_Click()
Dim strList As String
Dim db As DAO.Database
Dim tdf As DAO.TableDef
Dim strTest As String
Set db = CurrentDb
For Each tdf In db.TableDefs
strTest = LCase$(Left$(tdf.Name, 4))
If strTest <> "msys" And strTest <> "usys" Then
strList = strList & tdf.Name & ";" & tdf.RecordCount & ";"
End If
Next tdf
Me.lstTest.ColumnCount = 2
Me.lstTest.RowSourceType = "Value List"
Me.lstTest.RowSource = strList
End Sub
