multiple table columns in a DDL?

[Netnoobie]

Let me try to explain what I mean. Im converting an existing Access application (actually Access forms...a DISASTER of an "application" as my company calls it) that uses many DDLs. Well in a couple of them it seems as though there is a query bound to a DDL that lists 2 to 3 columns. So when selecting DDL1 the text looks something like:

Col1 |Col2 |Col3

Thats the text that appears. Can this be reproduced with .NET and DDLs? Ive tried replicating what the Access form is doing with no luck. I can do something like:

SELECT tblContainerType.ContainerType + | + tblContainerType.Description As Container

But it really doesnt look the way Big Brother wants.

So it is possible to bind a DDL and in doing so set the Text to three columns on a query? I know this is a stupid question, but the people dont want to lose the current look and feel along with the (supposed) advantage of seeing all possible information when making a selection.

Anyway, if anyone knows something that might help Id be very appreciative.

Thanks.

 

[Netnoobie]

Ok, Well Ive written a sub that creates the DDL items without binding. So I have more control over the content of the test and value. Now I run into an issue where I have the correct spacing but I cant get the DDL to accept them. Its always one space even when Im trying to write 4. I tried writing out non breaking spaces instead of just " " and the DDL doesnt translate them. All I see is "Type   | Description".

Any suggestions? Thanks.

 

[JIMcFadyen]

Have you tried using tabs?

I would try it but my server has given up for the week...

John

 

[Netnoobie]

I just tried tabas and I get the same results that I did using spaces. Thanks for the suggestion though.

I can admit this is getting quite annoying!