Wrox Programmer Forums
Go Back   Wrox Programmer Forums > Microsoft Office > Access and Access VBA > Access VBA
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
Old January 30th, 2008, 11:04 AM
Registered User
Join Date: Jan 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts
Default Listbox with varying background colors


I am trying to have a listbox where each row can be a different color to the other rows. This would be dependent on the content of the row.

I have tried googling around and no where seems to have an answer about how this is possible.

Thank for you for advice given, in advance :)

Kind Regards

Satal Keto

Old January 30th, 2008, 11:20 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

This is not possible in Access. You can only change the background colors for the entire control, not for a row. You can change the background colors of rows in a report, for example, but not within any control (list, combo, etc.)

Your option would be to create your own group of controls and use conditional formatting on each one, and allow them to act as a list box, but this would take some coding.

Did that help?


Look it up at: http://wrox.books24x7.com
Old January 30th, 2008, 11:23 AM
Registered User
Join Date: Jan 2008
Posts: 2
Thanks: 0
Thanked 0 Times in 0 Posts

Yes that was helpful thank you.
Unfortunately not the answer I was hoping for but ow well I will just have to see about either making a new control or finding another way :)

Again Thank you :)

Similar Threads
Thread Thread Starter Forum Replies Last Post
Alternating Colors in ListBox rows nkrust ASP.NET 1.0 and 1.1 Basics 2 January 10th, 2007 03:27 PM
Row colors in listbox canmex Access 1 November 18th, 2006 09:01 PM
Changing the colors of items in a listbox Thorgal ASP.NET 2.0 Professional 0 June 7th, 2006 02:37 AM
enable the 'Print Background colors and images' crmpicco Javascript 2 January 15th, 2005 03:26 AM
'Print Background colors and images' crmpicco Javascript How-To 0 January 14th, 2005 10:19 AM

Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.