Results 1 to 3 of 3

Thread: Font Color

  1. #1
    Join Date
    Dec 2003

    Unanswered: Font Color

    I have a report that needs to change colors based on a field. If the youth belongs to this Family Service Coordinator, then I want this color. Any suggestions?

    I tried conditional formatting, however this only allows me to change the font color of the family service coordinator. I need the youth that is attached to that family service coordinator's name to change color or be highlighted.

    Thanks for your help!


  2. #2
    Join Date
    Jan 2007
    California, USA
    Please show us the code you currently have. It really is a big help.

    I'm thinking you are looking for something like this:
    If FamilyServiceCoordinator = "Jim" Then
      Youth.BackColor = vbBlue
    ElseIf FamilyServiceCoordinator = "Bob" Then
      Youth.BackColor = vbGreen
    ElseIf FamilyServiceCoordinator = "Sue" Then
      Youth.BackColor = vbYellow
    End If

  3. #3
    Join Date
    Feb 2004
    Chicago, IL
    You can put anything you want in the Conditional Formatting if you change it to Expression Is. For the youth textbox change it and assuming the data for the Family Service Coordinator is in the Family Service Coordinator field then this should work:

    [Family Service Coordinator]="Jane Doe"

Posting Permissions

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