How to highlight a txtbox background according to another table?

To highlight a textbox background in Access based on a list of holidays from a table, you can use VBA (Visual Basic for Applications). You would typically set up an event, such as the On Current event of the form, to check if the date in the textbox matches any date in your holidays table. If it does, you can change the background color of the textbox accordingly.

Here’s a basic example of how you might implement this:

1. Create a form that contains a textbox (e.g., txtDate) to display the date.
2. Use the following VBA code in the form's code module:

      Private Sub Form_Current()
          Dim holidayDate As Date
          Dim rs As DAO.Recordset
          Set rs = CurrentDb.OpenRecordset("SELECT HolidayDate FROM Holidays")
      
          ' Reset background color
          Me.txtDate.BackColor = vbWhite
      
          ' Loop through the holidays
          Do While Not rs.EOF
              holidayDate = rs!HolidayDate
              If Me.txtDate.Value = holidayDate Then
                  Me.txtDate.BackColor = vbRed ' Change to your desired color
                  Exit Do
              End If
              rs.MoveNext
          Loop
          rs.Close
          Set rs = Nothing
      End Sub
   

3. Adjust the SQL query to match the name of your holidays table and the field containing the holiday dates.

This code checks each time the form is navigated to a new record and highlights the textbox if the date matches a holiday date from the table.

Make sure to enable the DAO reference in your Access VBA environment to use the DAO.Recordset object.

What do you mean by “calendar in Access”? Is this the stock calendar control, a user built form, or a report?