?
Solved

I need to make listbox transparent in MS Access 2003 form

Posted on 2010-08-18
4
Medium Priority
?
939 Views
Last Modified: 2013-11-28
I have a listbox containing 15 columns.......and I would like to highlight 3 columns....is there any possible way to do this from the following:

-> Can I just change the fore color (font colors) for last 3 columns?
-> Can I just change the back color or highlight for last 3 columns?
-> Can I just work around by making list box transparent and put a color rectangle behind last 3 columns ? For that I have to make listbox transparent and I don't see any property to change the back style???

Thanks
0
Comment
Question by:hitsdoshi1
4 Comments
 
LVL 77

Accepted Solution

by:
peter57r earned 501 total points
ID: 33466326
No you can't format a standard Access listbox.
It sounds like you should be using a subform if you want to apply formatting.
0
 
LVL 38

Assisted Solution

by:puppydogbuddy
puppydogbuddy earned 501 total points
ID: 33468961
This link shows you how to accomplish what you want using a ListView control instead of a listbox.

                         http://www.tek-tips.com/faqs.cfm?fid=5329
0
 
LVL 85

Assisted Solution

by:Scott McDaniel (Microsoft Access MVP - EE MVE )
Scott McDaniel (Microsoft Access MVP - EE MVE ) earned 498 total points
ID: 33473498
Stephen Lebans has some very cool tricks with Listboxes:

http://www.lebans.com/List_Combo.htm

I don't see one that specifically states you can color different columns, but if you dig through the samples you might find something that is of interest.
0
 
LVL 9

Author Closing Comment

by:hitsdoshi1
ID: 33502733
Thanks everyone...Well solution doesn't exist..so I will try workarounds and suggestions you guys provided...
0

Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Microsoft Access is a place to store data within tables and represent this stored data using multiple database objects such as in form of macros, forms, reports, etc. After a MS Access database is created there is need to improve the performance and…
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

850 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question