formatting field that has calculation

[splodgehodge]

Hsppy New Year and thanks all for your help, especially yesterday!

I have a field that has a calculation on it that looks at a field and then copies the contents into the field so that I will hopefully be able to use it for printing labels. The calc code I used was:

If (AF1L1P1 = "YES" ; AF1L1N1)&

If (AF1L1P2 = "YES" ; AF1L1N2)&

If (AF1L1P3 = "YES" ; AF1L1N3)

etc...

The problem is all the text copies but leaves no spaces inbetween.

I would like a line break inbetween the text.

Is this possible?

Thanks all

[efen]

If (AF1L1P1 = "YES" ; AF1L1N1)& "¶" &

If (AF1L1P2 = "YES" ; AF1L1N2)& "¶" &

If (AF1L1P3 = "YES" ; AF1L1N3)

Edited January 1, 2010 by Guest

[efen]

Case (

AF1L1P1 = "yes";AF1L1N1 & "¶";"") &

Case (

AF1L1P2= "yes";AF1L1N2 & "¶";"") &

Case (

AF1L1P3 = "yes";AF1L1N3 & "¶";"")

to remove any space if one is not "yes"

[splodgehodge]

Thanks for that.

Worked first time.

Have a great new year.