Re: Combo box

From: Tom (anonymous_at_discussions.microsoft.com)
Date: 06/28/04 

Date: Mon, 28 Jun 2004 13:46:27 -0700

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

Relevant Pages