Displaying two fields in a combo box

[BrianFawcett]

I am trying to display two fields from a table in one drop down list on a report. I am getting the first field, but not the second. I created a query and copied it into the Row Source field in the properties box. Here is my SQL statement:

SELECT DISTINCT tbl_SupplierPricing.SupplierCode, tbl_SupplierPricing.SupplierName FROM tbl_SupplierPricing WHERE (((tbl_SupplierPricing.SupplierCode) Is Not Null) AND ((tbl_SupplierPricing.SupplierName) Is Not Null));

Can anyone help me out?

 

[MarkK]

Hey there, welcome to the forum. Check out the ColumnCount and ColumnWidths properties of the list or combo control. These are on the Format tab of the property sheet of the control in design view.

 

[BrianFawcett]

I have Column Count of 1 and a Column width of 1.7396". Do I need to make the column count 2?

 

[rainman89]

Do you want both to show or only the supplier name?

if both, set column count to 2 and then set width to 1.7396"; 2" and adjust the 2 accordingly

 

[boblarson]

And remember it will only show when you drop it down. When a selection is made it will show the FIRST non 0" width field.

 

[boblarson]

If you want to show both at all times then you would need to use a concatenated field.