Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2002
    Posts
    154

    Question Unanswered: Changing property of all controls on a report

    Does anyone out there know of a way to change the forecolor of all textboxes in a row on a report based on a condition that is cleaner, so to speak, then enumerating every textboxes' name and setting the .ForeColor to a different color for each textbox? The condition involves left$(aField,2) and so is more complicated than conditional formating would seem to allow so I am using the On Format event of the detail section to set the forecolor to two different colors in Access 2002. Thank you in advance for your time and your responses.

  2. #2
    Join Date
    May 2005
    Location
    Nevada, USA
    Posts
    2,888
    Provided Answers: 6
    There are certainly ways to change all the controls, but I just tested this in conditional formatting and it worked fine:

    Left$([FieldName],2)="aa"
    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
  •