Results 1 to 9 of 9
  1. #1
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Change Font Colors (Access 2002)

    Hello All;

    In a condition statement like "=IIf([PostnType] Like 'A','ACTIVE','VACANT')"; I would like the Font color to be Blue for "Active" and red for "Vacant". How do you change the font colors?

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Font Colors (Access 2002)

    Where is this? In a query, or on a form, or on a report?
    If on a form, is it a single form or a continuous form?

  3. #3
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Font Colors (Access 2002)

    Sorry Hans;
    It is on a Form; the IIf statement is in a text box on a form.

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Font Colors (Access 2002)

    Thanks. Is it a single form that displays only one record or a continuous form that displays several records at once?

  5. #5
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Font Colors (Access 2002)

    The Form's Default View has been set to 'Continuous Forms'.

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Font Colors (Access 2002)

    Open the form in design view.
    Select the text box
    Select Format | Conditional Formatting...

    Leave the first combo box as it is (something like Field Value is.)
    Select "Equal To" in the second combo box.
    Enter "Active" in the text box to the right.
    Click the Font Color dropdown and select blue.

    Click Add >>

    Leave the first combo box as is.
    Select "Equal To" in the second combo box.
    Enter "Vacant" in the box to the right.
    Click the Font Color dropdown and select red.

    Click OK.

  7. #7
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Font Colors (Access 2002)

    Thank You work perfectly. Where can you find this type of documentation; So that I can read at as time permits. Otherwise I need to always logon to your site.

  8. #8
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Change Font Colors (Access 2002)

    >> Otherwise I need to always logon to your site.

    Is that so bad? I learned a lot of what I know of Access by avidly reading threads here as a guest, before I became a Lounger and started answering others' questions.

    Apart from that, almost any of the books on Access 2000 and Access 2002 will explain things like Conditional Formatting, but I find I learn more from being curious, seeing what the various menu options do, what properties are available and nosing around the help files, than by reading a book.

  9. #9
    2 Star Lounger
    Join Date
    Jul 2003
    Posts
    124
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Change Font Colors (Access 2002)

    Yes; that's basicly how I've learned to use this product. Thanks Again; I guess I'll have to stop by daily.

Posting Permissions

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