Text Boxes Storing Logged In User Information on Form

[AlexB123]

I'm working on several databases that manage user logins via storing the information entered in to the logon form on the "main" form page of my db's. For example:

inUserAccess = DLookup("UserAccess", "tblUsers", "[UserID]=" & txtUser)
    inUserName = DLookup("UserName", "tblUsers", "[UserID]=" & txtUser)
    inUserInitials = DLookup("UserInitials", "tblUsers", "[UserID]=" & txtUser)
    inUserID = txtUser
    
    
    [Forms]![frmMain].[txtUserAccess] = inUserAccess
    [Forms]![frmMain].[txtUserName] = inUserName
    [Forms]![frmMain].[txtUserInitials] = inUserInitials
    [Forms]![frmMain].[txtUserID] = inUserID

And

Forms!frmMain.txtMainWelcome = "You are logged in as: " & vbNewLine & Me!cmbName.Column(1)
        Forms!frmMain.txtMainUser = Me!cmbName.Column(0)
        Forms!frmMain.txtMainUserAccess = Me!cmbName.Column(2)

How many entries can a text box on a form store? Currently, the db's seem to handle multiple users, but I am unsure as to how. There is a "Logged_In" column on a user table in both db's, but access seems to depend on the storage of the data. I am considering a table that stores this information instead, and am trying to learn more about how this works. Can anyone shed some light or direct me in further research?

Many thanks!

 

[apr pillai]

I used a different approach for recording User activities by recording the events and user details in a text file outside the database. Take a look:https://www.msaccesstips.com/2008/06/database-open-close-event-alerts.html