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 February 29th, 2008, 08:19 AM
Authorized User
Join Date: Feb 2008
Posts: 34
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to hewstone999
Default Change the Appearance of a list box (Access VBA)

I currently have a list Box populated with some table data which has 9 columns and 255 rows.

I want to enhance the appearance of the list box i.e. 1 row of data will be blue, and next row will be white, and the next row blue again etc etc

How can I do this?

Kind Regards

Old February 29th, 2008, 09:12 AM
Friend of Wrox
Join Date: Mar 2004
Posts: 3,069
Thanks: 0
Thanked 10 Times in 10 Posts

You can't. Listboxes have BackColor controls, but they cover the whole list box and can't be seperated by rows. I don't think there are any controls in Access that would allow you to do this. Normally to get this effect, people use a continuous form, or do this when displaying data on a report.

Did that help?


Look it up at: http://wrox.books24x7.com

Similar Threads
Thread Thread Starter Forum Replies Last Post
List Available Fonts in Access VBA Nadine Access VBA 0 March 19th, 2008 12:24 PM
List Box Fliter MS Access VBA hewstone999 Access VBA 1 February 29th, 2008 09:01 AM
Add a Horizontal Scroll Bar to a List Box in VBA hewstone999 Access VBA 1 February 28th, 2008 08:31 AM
Access 97 VBA: Change file extensions yackyack75 Access VBA 2 December 1st, 2005 02:23 PM
How to change appearance of radio button BigBud Javascript How-To 3 March 22nd, 2005 10:34 AM

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