[AccessD] Column count and width through code

Susan Zeller szeller at cce.umn.edu
Thu Mar 27 10:10:19 CST 2003


Got it.  The "cm" is the key. Without it, I couldn't get this to work.

Thanks!

--Susan


-----Original Message-----
From: paul.hartland at fsmail.net [mailto:paul.hartland at fsmail.net] 
Sent: Thursday, March 27, 2003 10:07 AM
To: accessd at databaseadvisors.com
Subject: Re: [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.


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


More information about the AccessD mailing list