the Dotted Line

[thetravo]

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

[comment]

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.

[Lee Smith]

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, 2008 by Guest

[-Queue-]

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.

[thetravo]

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.

[thetravo]

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.

[mr_vodka]

See HERE

[thetravo]

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.

[Lee Smith]

post a copy of your file.

Lee

[David Jondreau]

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, 2008 by Guest