Mike and Doris Manning
mikedorism at ntelos.net
Thu Mar 27 09:58:59 CST 2003
Me.lstbox.ColumnWidths The value you pass it must be a string. For example, 3 columns with first one hidden, second one 1/2 inch and 3rd one 1 inch.... Me.lstbox.ColumnWidths = "0;.5;1" Doris Manning Database Administrator Hargrove Inc. www.hargroveinc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Susan Zeller Sent: Thursday, March 27, 2003 10:43 AM 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