Setting combo column width

[Guest]

Greetings all. In Access 2003 I have a form where I set the rowsource and
column count based on the value of a text box. What I need to do now is to
also be able to adjust the column widths like this

Private Sub label_click
me.mycombo.columnwidths = 1,3
Exit sub

I can not figure out the correct syntax. I have tried "1","3" "1,3" "1;3"
"1";"3"
but none of these work. Any ideas?

 

[Stephen Lebans]

At runtime, this property is expressed in Twips. There are 1440 Twips per
inch.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Guest]

Stephen, thanks for the quick reply. Could you maybe elaborate a little bit
on how I could manupulate the column widths with adjusting the Twips? If I
am able to set the column widths in the properties dialog box of the combo in
question with 1",3" format why can I not do this on the click event of
another control? When you say at runtime I am not sure what you mean. I
should have included that I am still trying to learn Access programming.
Thank you.

 

[Douglas J. Steele]

Through code, you use twips, not inches or centimeters.

Try:

me.mycombo.columnwidths = "1440, 4320"

 

[Guest]

Thanks once again Stephan and Doug. That worked like a charm.