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
Conditional Formatting in a List box
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formatting in a List box
Conditional formatting is only available for text boxes and combo boxes, not for list boxes.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Conditional Formatting in a List box
Thanks Hans! I appreciate the information.
-
- 4StarLounger
- Posts: 550
- Joined: 27 Jun 2021, 10:46
Re: Conditional Formatting in a List box
One possible solution is to use a subform set up in continuous forms mode to look like a listbox
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Conditional Formatting in a List box
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!
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!
-
- Administrator
- Posts: 78481
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Conditional Formatting in a List box
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.
It has always been this way.
Best wishes,
Hans
Hans
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Conditional Formatting in a List box
That is good to know! I most likely was always doing it the other way around! Thanks!
-
- 4StarLounger
- Posts: 550
- Joined: 27 Jun 2021, 10:46
Re: Conditional Formatting in a List box
It might look something like this:
You do not have the required permissions to view the files attached to this post.
-
- BronzeLounger
- Posts: 1488
- Joined: 05 Feb 2010, 22:25
Re: Conditional Formatting in a List box
Thanks so much! This will be perfect!