[AccessD] Column count and width through code

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



More information about the AccessD mailing list