Novice
Windows 7 64bit 
Access 2010 64bit
I have an unbound list box displaying records from a query on one of my forms. There are 7 columns, one of which is an IIF date diff function leading to one of three outcomes. Based on the calculated outcome, I would like it to be colored, either the entire record in the box or simply the calculated field. I know conditional formatting should take care of this, but it is grayed out. Is there any way I can make this happen?
VIP
Windows 7 64bit Access 2010 32bit
AFAIK, cannot color code listbox items by any means. Conditional Formatting is available only with textbox. Can have a textbox display values from each of the listbox columns by referencing listbox column index. Index begins with 0.
=
[listboxname].[Column](x)
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
VIP
Windows 7 64bit Access 2007
You could use a Subform (in Datasheet View) instead of a Listbox, and format it to look like a Listbox. You could then do your Conditional Formatting, and any other manipulation you need do with the data.
Linq ;0)>
Conditional Formatting: Background Color Rules for Only a Specific List of Text?
Change Font Color of Selected List Box Item
Posting Permissions
Reply With Quote