Re: Combo box

From: Gerald Stanley (gcstanley_at_d-s-l.pipex.comREMOVE-)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 00:42:56 -0700

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
>-----Original Message-----
>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
>.
>