anyway to overwrite a text box with another text box. not overlap

[Tbirdbully]

I am using crystal 11.

is there anyway to overwrite part of a text box with part of another box. This is what I am looking for.

product names page number
------------------------------------------------------
[Acrobat].....................................45
[Ascent Capture]..............................23
[Photoshop]...................................49
-----------------------------------------------------

I can't find a way to have the "......" start right after the product until it reached the page number.

I was thinking if I could make the product name overwrite the [..................... 45] and make the ......... go the whole length of line it may work. But of course I dont know how to do this.

Any Ideas? Thanks

 

[synapsevampire]

You can probably just drop the product field on top (not inside) the text box with the dots and get a similar look providing it's on top.

Otherwise you might use a formula that estimates the number of characters, and as long as you use a fixed width font it will work:

{table.product} + replicate(".",50-len({table.product})) + {table.pagenumber}

-k

 

[Tbirdbully]

Thanks for your reply.

Replicate() is not a valid formula function though. len shows up blue but replicate does not. Any idea?

 

[lbass]

Should be: replicatestring

-LB

 

[Tbirdbully]

Thanks synapsevampire and lbass!

You guys are great!