Tab-like output in a text field

[Joseph Greenberg]

I seem to recall reading about this at some point in distant history, but I
can't find any references online for it.

I have a bound calculated text field on a report which is based on several
fields, puncutation, etc (i.e., [Field1] & " - " & [Field2]). I'd like to
have [Field2] line up the same place horisontally on the page, no matter how
wide [Field1] is, without using that space-dash-space literal. Is there an
easy way to include a string that says something liik "go to the 2nd tab
stop", or "move over 1440 twips", or something like that, in the calc text
field?

Thanks.

Joseph

 

[fredg]

I seem to recall reading about this at some point in distant history, but I
can't find any references online for it.

I have a bound calculated text field on a report which is based on several
fields, puncutation, etc (i.e., [Field1] & " - " & [Field2]). I'd like to
have [Field2] line up the same place horisontally on the page, no matter how
wide [Field1] is, without using that space-dash-space literal. Is there an
easy way to include a string that says something liik "go to the 2nd tab
stop", or "move over 1440 twips", or something like that, in the calc text
field?

Thanks.

Joseph

Perhaps something like this?
=[Field1] & space(35-len([Field1])) & [Field2]

Using a proportional space font, the above will approximately align
the second field 35 spaces from the left border of [Field1].
If you need it to exactly line up the second column you will need to
use a non-proportional space font.

However, if you need the second field in an aligned column why
concatenate it with the first column.
Two separate controls ...
=[Field1] =[Field2]
should do it.

 

[Joseph Greenberg]

thank you. upon consideration the simple (second) solution actually probably
would work for me. duh!

I seem to recall reading about this at some point in distant history, but
I
can't find any references online for it.

I have a bound calculated text field on a report which is based on
several
fields, puncutation, etc (i.e., [Field1] & " - " & [Field2]). I'd like to
have [Field2] line up the same place horisontally on the page, no matter
how
wide [Field1] is, without using that space-dash-space literal. Is there
an
easy way to include a string that says something liik "go to the 2nd tab
stop", or "move over 1440 twips", or something like that, in the calc
text
field?

Thanks.

Joseph

Perhaps something like this?
=[Field1] & space(35-len([Field1])) & [Field2]

Using a proportional space font, the above will approximately align
the second field 35 spaces from the left border of [Field1].
If you need it to exactly line up the second column you will need to
use a non-proportional space font.

However, if you need the second field in an aligned column why
concatenate it with the first column.
Two separate controls ...
=[Field1] =[Field2]
should do it.