Multi Columns in Combo Box

[Guest]

How can I have my combo box in a form show 2 colums of data that are not
adjacent in the table that it references?
For instance if my table (Called Project Info) columns are named (going left
to right):
Project Project Name Project Number

And I want "Project" and "Project Number" to appear in the drop down of a
combo box, How do I do this?
Thanks in advance!

 

[Troy]

Set the Column Widths property at design or runtime.

In your case, it would be:

..5";0";.5"

--
Troy

Troy Munford
Development Operations Manager
FMS, Inc.
www.fmsinc.com


How can I have my combo box in a form show 2 colums of data that are not
adjacent in the table that it references?
For instance if my table (Called Project Info) columns are named (going left
to right):
Project Project Name Project Number

And I want "Project" and "Project Number" to appear in the drop down of a
combo box, How do I do this?
Thanks in advance!

 

[Guest]

Thanks! Works great!

 

[Guest]

The order that the fields appear in the table have no impact on their
placement in a combo box. In the design view of the form, go to the
properties of the combo box by right-clicking on the combo box and selecting
Properties. Click in the Row Source box. Click on the three dots. This is
where the order of the columns is determined for the combo box. If you want
to change it, float your cursor over the top of the column until it changes
to an arrow pointing downward. When it does, click on the column. The column
will turn black. With the column black, point at the very top of the column
and hold the left mouse button down, pulling the column in the direction you
want to move it.