columns in a subform

  • Thread starter Thread starter Peter Morris
  • Start date Start date
P

Peter Morris

How do I set the widths of columns in a subform
displayed as a datashhet?
 
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.
 
You must log in or register to reply here.

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
Running Balance in a DATASHHET 1
Sort Fields in Datasheet view 3
Subform - Datasheet View - Resize columns 1
How do I adjust column width programatically in subform 2
Subform in data sheet view 1
Changing a text box to a combo box ... oops. Can you help? 4
Multivalue Combo Boxes in Subforms 1

Back
Top