Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Category:
Forms & Form designer
>>>>I searched the threads, but to no avail... A Listbox based on SQL has 5 columns and displays all columns correctly when clicked and the list is displayed, but only shows the first column after selecting an item. I'm sure I'm just missing something simple here. Thanks!
>>>>
>>>>Regards, Renoir
>>>
>>>Renoir,
>>>If you mean combo then no you don't. It's default behaviour. Combine few fields to 1 column to show.
>>>Cetin
>>
>>I meant Listbox. Ok, I tried to concantenate fields and show using the DisplayValue, but it doesn't work. Where do I put the combined fields?
>
>Renoir,
>No I meant for combo. Then it's something else - Columncount ?
>What are the nondefault properties ?
>Cetin
Cetin,
Properties:
ColumnCount: 5
ColumnLines: .T.
ColumnWidths: 100,100,100,200,20
Enabled: .T.
FirstElement: 1
RowSource: SELECT code, type, desc, mfsystem FROM prgfiles\codes INTO CURSOR vCodesList
RowSourceType: 3 - SQL Statement
SelectOnEntry: .T.
Style: 2 - Dropdown List
I want to display all fields after item is selected.
Renoir
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only