microsoft.access.courses - Changing colour of selected items in listbox

The UK's most regular instructor-led training courses.
Training information: microsoft.access.courses · Access course microsoft training · VBA courses London UK

Resolved · Low Priority · Version Standard

Changing colour of selected items in listbox

Andrew has attended:
Access Advanced course
Access VBA course

by - delegate Andrew [4 posts] (2007 Aug 24 Fri, 14:54) Reply

How can I change the highlighting colour of selected items in a listbox? The default black on a white background does not look right in the colour scheme I am using and I can't find any way to set it in Access. I think I should be able to do it in VBA - any ideas?
Thank you
Andrew

Version	Date	Location	Places available	Book	Next place rate:
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 11 Thu	Tooting	0	FULL
2003	2008 Sep 19 Fri	Bayswater	5	book now	£195	£205
2007	2008 Sep 23 Tue	Bloomsbury	5	book now	£212	£224
2002/XP	2008 Sep 24 Wed	Tooting	0	FULL
2003	2008 Oct 7 Tue	Southwark	6	book now	£193	£215
Full Schedule: See all 72 Access Intermediate course dates. Bookings currently available until 24th November 2009.

RE: Changing colour of selected items in listbox

by - trainer Carlos gold contributer [413 posts] (2007 Oct 1 Mon, 11:51) Reply

Andrew

To Change the colour of a Listbox:

In design view

Right click the List box

Select Properties

Click the Format tab

Select and change Back Color And Fore Color

Hope this helps

Regards

Carlos

· Quick Access Course: Creating a Customer Contact Database in 8 Simple Steps
· Access Database Optimization: First Normal Form
· Microsoft Access: Unleash the True Potential Today
· Microsoft Access 2007: New Features
· Why consider Access Visual Basic training?

Access tip:

Splittng a database

Split your database into two (at least).

Keep all of your code, forms, reports, etc. in one 'code' database and all of your tables in another 'data' database which is then linked to the 'code' database.

This makes modifications, updates and back-ups that much easier and allows you to work on a new version of your 'code' database without affecting existing users. It also makes it easier should you wish to convert a single user databases into a multi-user networked version.

View all Access hints and tips