1. Assign Value to Textbox / Clear Value of TextBox 2. Set Focus to TextBox 3. Change bg color

Vba.TextBox.BgColor.vb

' Change color of textbox based on conditional (Frequest Use)

    If DirExists(WorkDirectory) Then
        MsgBox ("Work directory located.")
        Me.LabelStatus.Value = "Initial Checks Successful."
        Me.LabelStatus.BackColor = lngGreen
    Else
        MsgBox ("Work directory: " & WorkDirectory & " was not located. Please restart application.")
        Me.LabelStatus.Value = "Initial Checks Unsuccesful. Work Directory not located"
        Me.LabelStatus.BackColor = lngRed
    End If

Vba.TextBoxAssign.vb

' When Assigning values to textboxes : Important to check which table field 
' each textbox corresponds with, and what data type it is.


' Assign date value to TextBox
Me.TextBoxCurrDate.Value = Format(Date, "mmddyy")

' Assign current user value to TextBox
Me.TextBoxCurrUser.Value = CurrentUser()

' Assign normal value to TextBox
Me.TextBox3.Value = "Panagos"

' Clear value of textbox 
Me.TextBox3.Value = Null

Vba.TextBoxFocus.vb

' Set TextBoxFocus
' Set focus to starting Textbox - Usually handled in form load
    Me.TextBoxPod.SetFocus