Hi Dears
I have form has many records.
I need some records coming font view with red color
THANKS
Printable View
Hi Dears
I have form has many records.
I need some records coming font view with red color
THANKS
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,
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
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.
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
I asked:You responded:Quote:
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.
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"Quote:
conditions should cause I have important records need to be red font
Hi GolferGuy
I upload sample file for what I need.
thanks
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.
Hi GolferGuy
can you make record number 1 and 4 red font as important record?
thanks
Hi GolferGuy
record important as the name of department or division.
thanks
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.
Hi GolferGuy
If can not be able Mechanism what about option button or check mark to select red font for some records.
thanks
Hi GolferGuy
Thank you so much for your efforts.
I get resolve by option button.