Combo box

[Tom]

We are using a combo box to hold a list of delivery
address's held in a existing table.
At present the combo box will only show the first line of
that address. Would like to have the combo box show the
first two lines.

Is this possible to achieve - if so how?

Thanks in Advance

Tom

 

[Gerald Stanley]

Where the RowSource SQL has something along the lines of
SELECT addressLine1 etc
try changing it to
SELECT addressLine1 & ", " & addressLine2 etc
to give you the two lines in a single column.

If you want the address lines in their own columns, it
would need changing to
SELECT addressLine1 , addressLine2 etc
and you will need to change the columnCount property.

You will have to change addressLine1 and addressLine 2 to
suit the column names in your own app.

Hope This Helps
Gerald Stanley MCSD

 

[Tom]

Gerald

The delivery address is held in 1 field so unfortunately
this suggestion would not work in this instance - can you
suggest an alternative

Tom