[AccessD] Column count and width through code

Sorry Susan,

I messed up with the last code, the ColumnWidths property should be set like this

Me.ComboBox.ColumnWidths = "0cm;1.0cm;2.0cm;3.0cm;4.0cm"

Paul


From: "Susan Zeller" <szeller at cce.umn.edu>
Date: Thu 27/Mar/2003 15:43 GMT
To: <accessd at databaseadvisors.com>
Subject: [AccessD] Column count and width through code

I have a listbox whose rowsource changes depending on other selections
from the user.  In one case I need 3 columns, in the other case, 5
columns.  Can I set the number of columns and the width of the columns
through code?  I found me.lstbox.columncount which I assume gives me the
count.  But, I can't find the equivalent in code of "column widths" in
the properties window.  I'm thinking this is simple, but it is escaping
me.  I'm in Access 2002.

--Susan


Susan B. Zeller
Office of Information Systems
College of Continuing Education
University of Minnesota
306 Wesbrook Hall
77 Pleasant Street SE
Minneapolis, MN 55455
Phone:  612-626-4785
Fax:  612-625-2568


_______________________________________________
AccessD mailing list
AccessD at databaseadvisors.com
http://databaseadvisors.com/mailman/listinfo/accessd
Website: http://www.databaseadvisors.com


__________________________________________________________________________
Join Freeserve http://www.freeserve.com/time/

Winner of the 2003 Internet Service Providers' Association awards for Best Unmetered ISP and Best Consumer Application.