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