Concatenate and Justify

[libraccess]

Back Again maybe this a query question



In the query I have this expr

DescBuilder: [Name] & ", " & [Code]

In the form the concantenation is in a combo box and I would really like to have the Name left justified (it is) and the Code Right Justified is this possible anybody
I've thought maybe 2 combos and have the second populated from the first selection but if I can right format the Code that would be really good

[June7]

Will require a custom VBA function to 'pad' [Code] with preceding spaces.

Review http://support.microsoft.com/kb/96458