Combo Boxes

[Ally]

I made a combo box and typed in some values in Row Source (with quotation
marks and semi-colons), however, only some of the values show up in the form
view. If I go to Design View and click on Data on the Property Sheet they all
show up in the Row Source field.

 

[Ken Sheridan]

Check that the ColumnCount property of the combo box is 1, and the
ColumnWidths is left blank. My guess is that you might have inadvertently
set it up so that it has more than 1 column and the missing values are going
into a hidden column.

You don't need to wrap each value in quotes BTW; just the characters with
each item delimited by a semicolon will do.

If you still have problems copy the string for the RowSource property to the
clipboard and paste it into a post back here.

Ken Sheridan
Stafford, England