Results 1 to 13 of 13

Thread: some records coming font view with red color

  1. #1
    Join Date
    Apr 2007
    Posts
    38

    some records coming font view with red color

    Hi Dears

    I have form has many records.

    I need some records coming font view with red color

    THANKS

  2. #2
    Join Date
    May 2006
    Posts
    407
    Please explain this with some detail so we can understand where you want the red font, what conditions should cause the red font, what kind of form (one record, continuous, or datasheet) is this on.
    thanks,

  3. #3
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    I need red font in some records and other record as defult font.
    I have continuous form
    conditions should cause I have important records need to be red font
    thanks

  4. #4
    Join Date
    May 2006
    Posts
    407
    With the form in design view, right click on the field you want to have the red font, select Conditional Formatting on the pop up menu. You can select "Field Value Is", Expression Is", or "Field Has Focus". Then you just put in your expression for "Record" = "Important" then set the font for red. That should do it.

  5. #5
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    I tried use Field Value Is equal to "Record" = "Important"
    then I tried again by Expression Is "Record" = "Important"
    but nothing change

    thanks

  6. #6
    Join Date
    May 2006
    Posts
    407
    I asked:
    Please explain this with some detail so we can understand where you want the red font, what conditions should cause the red font, what kind of form (one record, continuous, or datasheet) is this on.
    You responded:
    conditions should cause I have important records need to be red font
    I asked for detail about conditions should cause the red font and you answered "important records". There is no test that I know of for "important records" so I made one up. Until you explain with some detail, that is the best I can do. There is no way I can guess what ever your rule or test is for an "important record"

  7. #7
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    I upload sample file for what I need.

    thanks
    Attached Files Attached Files

  8. #8
    Join Date
    May 2006
    Posts
    407
    I have looked at your database and I don't see anything that makes me think "Important Record" You are going to have to explain to me what makes a record important, otherwise I can't help.

  9. #9
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    can you make record number 1 and 4 red font as important record?

    thanks

  10. #10
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    record important as the name of department or division.

    thanks

  11. #11
    Join Date
    May 2006
    Posts
    407
    Neither department or division is referenced in the form that is in the database you posted.

    You can use "Conditional Formatting" to make the "Hospital" record have a Red background. You get to "Conditional Formatting" dialog box by right clicking on the field in design view, then select "Conditional Formatting" from the popup menu.

  12. #12
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    If can not be able Mechanism what about option button or check mark to select red font for some records.

    thanks

  13. #13
    Join Date
    Apr 2007
    Posts
    38
    Hi GolferGuy

    Thank you so much for your efforts.
    I get resolve by option button.

Posting Permissions

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