Conditional Formating in Forms

VKKT
2StarLounger
Posts: 184
Joined: 13 Jun 2018, 07:50

Conditional Formating in Forms

Post by VKKT »

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

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Formating in Forms

Post by HansV »

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.

S0086.png
You do not have the required permissions to view the files attached to this post.
Best wishes,
Hans

VKKT
2StarLounger
Posts: 184
Joined: 13 Jun 2018, 07:50

Re: Conditional Formating in Forms

Post by VKKT »

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

User avatar
HansV
Administrator
Posts: 78235
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Conditional Formating in Forms

Post by HansV »

It should work - I have tested it.
If you wish, you can attach a zipped copy of the database.
Best wishes,
Hans

VKKT
2StarLounger
Posts: 184
Joined: 13 Jun 2018, 07:50

Re: Conditional Formating in Forms

Post by VKKT »

Sorry Mr. HansV, It is working, I made some wrong reference of field name

Thanks a lot
VKKT
:cheers: :cheers: