Results 1 to 4 of 4
  1. #1
    Join Date
    Aug 2011
    Posts
    56

    Unanswered: Change Textbox Background On Report Using If Statement

    Access 2007

    I am creating a maintenance checklist report. The data comes from a query of 3 tables (Components, MaintenanceChecks, ComponentMaintenanceChecks). The report queries component description, maintenance check description and service interval. The options for service interval are either 250, 500, 1000 or 2000. In the report detail, I want to create a checklist like this:

    [Component] [MaintenanceCheck] [txt250] [txt500] [txt1000] [txt2000]

    I was wondering if it is possible, for each record, to change the background formatting of [txt250], [txt500], [txt1000] or [txt2000] depending on the value of the service interval for each record.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    Have you looked at Conditional Formatting on the ribbon? That would be the simplest way to do it.
    Paul

  3. #3
    Join Date
    Aug 2011
    Posts
    56
    Yea I simplified the way I was doing it by adding yes/no fields for each interval option to the table and using conditional formatting to shade the boxes.

  4. #4
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    I don't see the need for yes/no fields, but glad you have a solution.
    Paul

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •