Conditional Formatting in a List box

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Conditional Formatting in a List box

Post by Leesha »

Hi,
I have a form with a listbox called lstMedicalDX. It is set to 4 columns. Only the second and third columns are visible. Column 3 is called PathwaySymptomIssue and is a true/false box. I would like to know if it's possible to set conditional formatting in the list so that if PathwaySympromIssue = True the background of the row is set to yellow, otherwise it is the normal color of a listbox.
Thanks!
Leesha

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

Re: Conditional Formatting in a List box

Post by HansV »

Conditional formatting is only available for text boxes and combo boxes, not for list boxes.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Conditional Formatting in a List box

Post by Leesha »

Thanks Hans! I appreciate the information.

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: Conditional Formatting in a List box

Post by SpeakEasy »

One possible solution is to use a subform set up in continuous forms mode to look like a listbox

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Conditional Formatting in a List box

Post by Leesha »

Hi SpeakEasy,
I don't know how that would work. Every time I've tried to do a continuous form within another form I get an error that says it can't be done. Has that changed or more likely, what have I been doing wrong?
Thanks!

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

Re: Conditional Formatting in a List box

Post by HansV »

A continuous form can be a subform of a single (standard) form. It cannot be a subform of another continuous form.
It has always been this way.
Best wishes,
Hans

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Conditional Formatting in a List box

Post by Leesha »

That is good to know! I most likely was always doing it the other way around! Thanks!

User avatar
SpeakEasy
4StarLounger
Posts: 536
Joined: 27 Jun 2021, 10:46

Re: Conditional Formatting in a List box

Post by SpeakEasy »

It might look something like this:
access.png
You do not have the required permissions to view the files attached to this post.

Leesha
BronzeLounger
Posts: 1484
Joined: 05 Feb 2010, 22:25

Re: Conditional Formatting in a List box

Post by Leesha »

Thanks so much! This will be perfect!