Concatenation problem displaying in combo box

[canadianinmd]

This is basically my problem I have data comming from a database and storing fields in a variable ie

Name = ORs("Name")
Address= ORs("Address")
DisplayVar = Name: Address


My goal is to display these values in a combo box as a concatenated variable.
However, by example..here is my problem
when I run a for loop to add DisplayVar to a combo box I get values exactly like this:

Tom Smith 3444 Taylor Road
Chris Stevens 34 McDonald Avenue
My goal is to have this type of display within the combo box:
Tom Smith 3444 Taylor Road
Chris Stevens 34 McDonald Avenue

ie I the fields
I have tried string functions to add extra spacies to the shorter names to make everything a consistent length, but the alignment is still off.
Does anyone have any suggestions ? Thanks for your help as it is greatly appreciated.
NOTE.. i noticed how this posted and never had the fields lined up.. But I think the post is clear in the sense I want the fields ie Tom's address and Chris's address to line up under each other.

[gits]

hi ...

welcome to TSDN ...

could you post what you have tried? ... may be adding a number of   instead of ' ' could do the trick?

kind regards