ColumnWidth Property Combo Box

[Marilyn]

I am trying to set the ColumnWidth property via VBA. This
is the statement that I've used:

Me.cboEmpid.ColumnWidth = ".5 in;1 in;1 in"

Error Message is: Type mismatched.

What is theproper syntax.

Thank you for your help.

 

[Gerald Stanley]

Try
Me.cboEmpid.ColumnWidths = ".5 in;1 in;1 in"

Hope This Helps
Gerald Stanley MCSD

 

[Cranky]

..5", 1", 1

You can always use a wizard to build one and then look at the properties you need


----- Marilyn wrote: ----

I am trying to set the ColumnWidth property via VBA. This
is the statement that I've used:

Me.cboEmpid.ColumnWidth = ".5 in;1 in;1 in

Error Message is: Type mismatched

What is theproper syntax

Thank you for your help

 

[Stephen Lebans]

At runtime the units must be expressed as TWIPS(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.