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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Unremovable horizontal scroll bar on subform 1
Format column widths from one table to a separate table on same page 1
Footer text appears "squished" 1
Mail Merge Directory Conditional Page Break 0
column width in continuous form 1
VBA - (re-) Set a Table Style 2
Excel Column Width in XLSX 0
Text in note pane of "normal" display suddenly much larger 1

Top