ColumnWidth

[Warrio]

Hi I have a code in which I want to hide columns when some criterias are
verified.

The end of my code is

Me.NumberID.ColumnWidth = 0; 0.5; 0 ; 0


Then it replies me the error Type Mismatch.

How should I write the criterias of ColumnWidth?

 

[Allen Browne]

Try writing the values in "twips".
1440 twips = 1 inch.

 

[Neil]

Also, the column width property is a string so you need to include ". e.g:

Me.NumberID.ColumnWidth = "0; 0.5; 0 ; 0"

HTH,

Neil.

 

[Warrio]

But with what do I separate the values?
It doesn't accept points, comas, etc...
Cause the combo has four columns. So I want to show only one.

 

[Allen Browne]

The property name has an "S" at the end.
Assign a string.
Use the semicolon as separator.

Result:
Me.NumberID.ColumnWidths = "0;770;0;0"