Code to right and left justify in one control

[Ruegen]

I would like to know if there is a way to justify two parts of a control into separate positions

if I had all in the same line/control

[person] & " " & [date] & [location]

So instead of it reading like this

|John Smith 12/12/2014 Summerhill ____spaces___|

it would read

|John Smith 12/12/2014 ____spaces____SummerHill|



I don't know of any functions that could be wrapped around the fields but that would be helpful....

[orange]

There is a Space() function in Access.

Suppose [person] is typically 20 chars., [date] is 10 and [location] is 15.
You could do something like (***untested***)

[person] & " " & [date] & space(30 - len([location])) & [location]

Good luck.

[Ruegen]

There is a Space() function in Access.

Suppose [person] is typically 20 chars., [date] is 10 and [location] is 15.
You could do something like (***untested***)

[person] & " " & [date] & space(30 - len([location])) & [location]

Good luck.

I could calculate the whole length and minus all three fields as each will be different.

I'll see how it turns out

Thanks

[Ruegen]

Hey it's working however how can I find out the exact amount of spaces in a control?

[Ruegen]

I'm using

=Trim([ShowName]) & Space((100-Len(Trim([showname])))-Len(Trim([blurb]))) & Trim([blurb])

in the control of the report field but it gives me random results - does this mean it does a one size fits all for the report or can each different row have it's own spacing?

[June7]

Probably won't get the effect you want with proportional fonts. Try Consolas.

[Ruegen]

Probably won't get the effect you want with proportional fonts. Try Consolas.

I thought it might be that (non monospaced font) :-/