I just need a little help. I am trying to figure out on how to add a dotted line before words in a field. Say for example (the field in red is what I want automatically changed)

Measurements: [color:red].............7.45 x 5.46 x 2.53 mm

Measurements: [color:red].......................0.76 x 1.26 mm

I would like the dots to be autimatically added or subtracted in the length of the field before the word or numbers.

Thank you

Is this all in the same field, or is it a text object with the field merged? In any case, this is done with a right tab, with a period selected as the fill character in the tab definition.

You could also use the Right Function if you wanted.

I would use the Auto Enter by Calculation, or a second field with a calculation, something like this,

Right ( text & "....................................................." & text; 30 )

Adjust the dots, and the "30" to fit your need.

If you need help with the Auto Enter Calculation, let me know.

Lee

Edited April 4, 200817 yr by Guest

Or

Right( Substitute( 10^(30 - Length(yourField)), "0", "." ) & yourField, 30 )

to allow easy changes to the number of periods used.

You would have to use a monospaced font to ensure everything lines up nicely.

I forgot to mention that the word Meassurements: is just text on the layout. The actual measurements is a separate field extending towards the text.

Right( Substitute( 10^(30 - Length(Measurements)); "0"; "." ) & Measurements; 30 )

Would that be correct and this would be a new calculation field on top of the field (measurements) I already have?

Thank again.

I tried the Tabs button. Though not sure I got it correct cause nothing happened.

I right clicked on the field then clicked Text formatt.... Then I clicked on paragraph... Then to Tabs... From here I clicked on Right then made the position to 1.00 px and set the fill character to a period.

See HERE

Yeeaaa so I tried the Tabs field and still doesn't work for me. I feel FM challenged right now. Well all I need are those dots before the word or number (since I aligned the text in the field to the Right) to extend the designated length of the field. Thank again for all the replies anyways.

post a copy of your file.

Lee

Is there some requirement that you have dots before the numbers? Why not make it easy and use a gray line running the whole length or set the field to display text baselines and make the field the whole width?

Or you could just use a calc'd field as others have said, but just have a leading 100 dots followed by the actual field.

Edited April 12, 200817 yr by Guest