DataSheet Column Width Control

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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.
 
Back
Top