I created a combo box on a firm that populates from a table. It has license plates, VIN, make & model in the table. When I drop down on the box, I only see the plate number. I'd like to list them all in the drop down. What step did I miss?
I created a combo box on a firm that populates from a table. It has license plates, VIN, make & model in the table. When I drop down on the box, I only see the plate number. I'd like to list them all in the drop down. What step did I miss?
A combo box has a record source, and that is a query or a table. It has properties as to which fields are visible as well as their width. You must adjust the combo box's properties.
Where do I adjust the properties for the combo box on the form?
When the form is in design view, and the combo box is highlighted; In the property sheet to the right
specifically 'Column Count' which has width of each column separated by ; symbol....if you only have one value there then just add a semi colon and the number 1 and the 2nd column will show 1 inch wide
be sure to also widen the 'Width' value and equal amount
Perfect! Thank you!