Label Cap in Continuous Form - Microsoft Access Forum


	Back to Access Forum Comments List

Upload Images @Reply Bookmark Link Email Next Unseen

Label Cap in Continuous Form

James Hopkins

2 years ago

Hey Richard and the Guys, I wonder if there's the a way the set a Label Caption in an Continuous Form. I am try to use a Label to Clock In/Out to display the Status of the Timesheet.

	Sami Shamma @Reply 2 years ago
Please be more specific. See Rule #2.

	Sami Shamma @Reply 2 years ago
You can use : Label name.Caption = 'new caption'

James Hopkins OP @Reply

2 years ago

Here's the Code I have in the Form:

Details

Private Sub Form_Current()



    If IsNull(TimesheetID) Then Exit Sub

    

    If TimeClockStatusID = 292 Then

        LblClockStatus.Caption = "Clock-Out"

        LblClockStatus.ForeColor = vbRed

    ElseIf TimeClockStatusID = 293 Then

        LblClockStatus.Caption = "Clock-In"

        LblClockStatus.ForeColor = vbGreen

    End If

    

End Sub

Details

Private Sub Form_Load()



    If IsNull(TimesheetID) Then Exit Sub

    

    If TimeClockStatusID = 292 Then

        LblClockStatus.Caption = "Clock-Out"

        LblClockStatus.ForeColor = vbRed

    ElseIf TimeClockStatusID = 293 Then

        LblClockStatus.Caption = "Clock-In"

        LblClockStatus.ForeColor = vbGreen

    End If

    

    RequeryFilter

     

    SetDefault

    

End Sub

	Sami Shamma @Reply 2 years ago
Again Please be more specific. See Rule #2. What is the question?

	James Hopkins OP @Reply 2 years ago
I am try to make the Label display the Status of the Employee Clock Status, if they are 'Clocked-In or Clocked-Out'. Right now the Label only display one Status for all.

	Kevin Robertson @Reply 2 years ago
Add a field to the Table and set the value of the Text Box based on whether the employee is clocking in or clocking out. Or build a Query with a calculated field that sets the value.

	Alex Hedley @Reply 2 years ago
Unchecked or tested but SO pointed to http://www.lebans.com/tooltip.htm

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Forum.

Next Unseen

New Feature: Comment Live View