Contenate & Right Justify

[idmnstr via AccessMonster.com]

Hi,

I started this code from a previous post. I want to concatenate these three
columns but the last column needs to be right justified in the space that
remains in the overall lengh of 26 positions.

LName & ", " & FName & SPACE(26-(LEN([LName] & ", " & [FName] & "") + LEN(
[CIS_Id] & ""))) & CIS_Id AS [NAME FIELD]

The result does not right justify.

 

[fredg]

Hi,

I started this code from a previous post. I want to concatenate these three
columns but the last column needs to be right justified in the space that
remains in the overall lengh of 26 positions.

LName & ", " & FName & SPACE(26-(LEN([LName] & ", " & [FName] & "") + LEN(
[CIS_Id] & ""))) & CIS_Id AS [NAME FIELD]

The result does not right justify.

Are you displaying the result using a non-proportional spacing font?
Try using Courier.

By the way, what's the purpose of the & "" in this
....... [CIS_Id] & "")

 

[idmnstr via AccessMonster.com]

fredg,

Yes, You are correct. The code did work afterall. The display was scewed
because some characters were wider than others in the font I was using to
display the results..

No, I do not know what & "" does for me in the code. It was in the example I
used from this forum. I don't believe it was explained there either.

Thank You