Hi,
Hope all are ok.
I want to format a field in the form if the value of another field of the same form has certain specific value.
Like if in the status field the value is "approved" all the fields in the form of that specific record should be conditional formatted (back Color) with a specific color to visually identify.
Hope this is clear.
Awaiting your valued response.
Regards,
VKKT
Conditional Formating in Forms
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formating in Forms
Select the text boxes and combo boxes that you want to format conditionally.
On the Format tab of the ribbon (under Form Design Tools), click 'Conditional Formatting'.
Click 'New Rule'.
Leave the list box 'Select a rule type' set to 'Check values in the current record or use an expression'.
Select 'Expression is' from the first dropdown box.
Enter the following expression in the box next to it:
[Status]="approved"
where Status is the name of the field you want to check.
Select the desired background color from thr dropdown with the paint bucket.
Click OK, then click OK again.
On the Format tab of the ribbon (under Form Design Tools), click 'Conditional Formatting'.
Click 'New Rule'.
Leave the list box 'Select a rule type' set to 'Check values in the current record or use an expression'.
Select 'Expression is' from the first dropdown box.
Enter the following expression in the box next to it:
[Status]="approved"
where Status is the name of the field you want to check.
Select the desired background color from thr dropdown with the paint bucket.
Click OK, then click OK again.
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 13 Jun 2018, 07:50
Re: Conditional Formating in Forms
Thanks Mr Hans for the quick response. I tried this but it is not working for forms, but for reports it is working.
Regards
VKKT
Regards
VKKT
-
- Administrator
- Posts: 78540
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formating in Forms
It should work - I have tested it.
If you wish, you can attach a zipped copy of the database.
If you wish, you can attach a zipped copy of the database.
Best wishes,
Hans
Hans
-
- 2StarLounger
- Posts: 184
- Joined: 13 Jun 2018, 07:50
Re: Conditional Formating in Forms
Sorry Mr. HansV, It is working, I made some wrong reference of field name
Thanks a lot
VKKT
Thanks a lot
VKKT