TABs in concantinatied text strings

[puforee]

I have a drop down control that shows 8 columns when selected but of course only shows one of the columns after selection. So, I got the Idea that if I concatenated all the fields with some text and set all row size values to 0 except the concatenated field....after selection it would show. Small problem...the number of characters per field being different causes the dropdown list to look sloppy.

Is there a way I can insert a TAB within my concatenated string (and set its width) so I can line up my concatenated data?

 

[Remou]

No, there is not. However, you could use a few textboxes to display the data using the column property of the combo:

=Me.cboCombo.Column(2)

Note that column numbering starts from zero. You could also use a listbox.

http://lessthandot.com

 

[puforee]

Thanks Remou,

Oh well, I was hoping but....yes I know the column thingy, I have used that in the past...thanks,