P Peter Morris May 25, 2006 #1 How do I set the widths of columns in a subform displayed as a datashhet?
G Graham Mandeno May 25, 2006 #2 Hi Peter Use the control's ColumnWidth property. For example: Me.CustomerName.ColumnWidth = 2880 This sets the width to 2880 TWIPs, or 2 inches. (A TWIP is a "TWentIeth of a Point", or 1/1440 inches) Setting it to the special value of -2 sizes the column to fit the visible text.
Hi Peter Use the control's ColumnWidth property. For example: Me.CustomerName.ColumnWidth = 2880 This sets the width to 2880 TWIPs, or 2 inches. (A TWIP is a "TWentIeth of a Point", or 1/1440 inches) Setting it to the special value of -2 sizes the column to fit the visible text.