DataSheet Column Width Control

K

KenGue

I've created a sub form as a DataSheet. When it opens each column is sized inappropriatley. Is there a way to set the size of each column so that the sub form opens with column widths I wish.
 
F

fgutkind

I've created a sub form as a DataSheet. When it opens each column is sized inappropriatley. Is there a way to set the size of each column so that the sub form opens with column widths I wish.
Click to expand...

Look up the ColumnWidth property in Help.

In the Form's Load event:
[SomeField].ColumnWidth = 1.25 * 1440

The value is set using Twips.
There are 1440 Twips in one inch.
The above code will set the column width of that column to 1.25
inches.
 
Top