fusion of 3 text fields with middle field underlined

[curious99]

Hi,

I'm creating labels.

I have 3 text fields :

prefix

base

suffix

I have a calculation field with text as a result that goes like this:

prefix & " - " & base & " - " & suffix

I want the result to be :

prefix - base - suffix

So I used the conditional format :

value comprised between - and -

but I do not obtain the desired result. Any suggestions?

Thanks

PS this is a liberal translation of the Filemaker commands as my software is french. If you need further explainations, please let me know.

[LaRetta]

Try calculation ( result of text ):

prefix & " - " & TextStyleAdd ( base ; Underline ) & " - " & suffix

Conditional format will not work here because there is no condition to be met - you always want it underlined.

Edited November 24, 2008 by Guest

[LaRetta]

Wait a minute ... LABELS? Then type the text you want as:

prefix - base - suffix

... then enter the text box again and double-click the word 'base' and select Format > Style > Underline.

[curious99]

Thanks LaRetta,

That was quick! I'll give it a try.

Cheers,

Luc

[curious99]

Hi LaRetta,

It worked : great!

Now I'd like to have it underlined, bold and italic! How do I achieve that goal? As you can see, I'm a very demanding type of guy :

Thanks again,

Cheers,

Luc

[LaRetta]

Are you using a calculation or a text label?

[LaRetta]

If calculation ...

prefix & " - " & TextStyleAdd ( base ; Underline+bold+italic ) & " - " & suffix

[curious99]

Hi LaRetta,

Thanks once more. Your suggestion made the trick1 Indeed, it was calculation.

I tried one more style of my own but it did not accept it : +capitalized ( cap lock). I guess that variation does not exist!

Cheers,

Luc

[LaRetta]

prefix & " - " & [color:green]Upper ( TextStyleAdd ( base ; Underline+Bold+Italic ) [color:green]) & " - " & suffix

[curious99]

Hi LaRetta,

You can't be beat!!!

All is perfect now, thanks once more.

Have a great evening,

Cheers

Luc