Results 1 to 2 of 2
  1. #1
    Join Date
    Aug 2002
    Posts
    78

    Unanswered: Conditional Formatting Access 2K

    I am working on a form in a database I am working on for a non profit. It is on a tab control. I am trying to conditional format the name of a person based of if they receive services, provide services or both.

    tblContacts is pretty standard
    FName
    MI
    LName
    Address
    City
    State
    Zip
    RecServices (check box)
    ProvServices (check box)

    I orignally wanted to use the check boxes but the Conditional Formatting doesn't work when both are checked. (e.g. if both fields are checked it formats to RecServices as that is the first formatting option)

    I opted to use an option box as there are only three options. tblContact has the field "Services" formatted as text.
    Receive Services is set at 1
    Provide Services is set at 2
    Both is set at 3
    I am using the code below to use the Conditional Formatting however there is something not working. Does anyone have a clue?

    DLookUp("[LName]","tblContacts","[Services] = 1")

    Any help would be greatly appreciated

  2. #2
    Join Date
    Aug 2002
    Posts
    78
    Nevermind


    [Services]=1
    [Services]=2
    [Services]=3


    Worked. not sure how I made it more difficult than it really was????

Posting Permissions

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