Contenate & Right Justify

  • Thread starter Thread starter idmnstr via AccessMonster.com
  • Start date Start date
I

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.
 
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.
Click to expand...

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] & "")
 
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
 
Back
Top