How do you make the column width on a subform match the property settings?

[dijilator]

As far as I can tell, I've set the column widths properly on the subform, but the down arrow on the list box is still outside of the selection area. It may have something to do with lookups or concatenations, but I'm not finding that so in what I can think of to trace down.

I exagerated the width of the list box to show where the down arrow actually shows itself.

See the form "frm_Class_Skills_Update" in the attached database. I need it to be visible when the list box is about 1.25" more narrow.

 

[JHB]

Set it in the form's on load event.

Me.Skill_ID_fk.ColumnWidth = 3500

 

[MarkK]

Also, Access measurements are in "twips," of which there are 1440 in an inch, so to show 1.25", you'd use

width = 1.25 * 1440