Can I format the text output in a Calculation

[joseph1000]

I have a large (dimension) calculation that results in a formated paragraph of text. The input is some boilerplate text and check box value list selections. There are a total of 10 check box selections that can be added to the paragraph but not all 10 will always be needed. I need to have each check box selection separated from the next by a carriage return. If all 10 are selected the paragraph looks great, but if for instance only 4 or 5 are selected, additional space is inserted into the paragraph where the non-selected entries normally would be. So here is my question: is there some way to format the field or a function that will force the calculation to dynamically format the field for the proper spacing when not all 10 selections are chosen?

Thanks,

Joe

[Anatoli]

You can remove the spaces or carriage returns by Substitute() in the result.

[joseph1000]

Anatoli,

I forgot to mention that I want to maintain a line space between check box selections. Can I still use Substitute()?

Thanks

Joe

[Anatoli]

I guess yes. Replace two or three with single . It should work.

[Fenton]

There is another way. Include the

[BobWeaver]

It seems strange that you get extra space when you only select a few items. No matter which combination of items you check, Filemaker should only put a single

[joseph1000]

Thanks for all the replies. I never did try and figure out how to use Substitute or Fenton's solution. I had to get the DB to the people who needed it, so they'll just have to deal with the extra spaces.

Bob, I included a carriage return between each check box field in the calculation because I wanted to ensure that there would be a space between each. What I'd hoped is that if say the 2nd check box was empty, it wouldn't show up in the calc field and the 3rd check box would somehow slide up to be under the first (while maintaining a space between the 1st. and 3rd.).

Anyway, thanks. When I get some extra time (yeah right) I'm going to try and figure out Anatoli's solution and give Fenton's a try as well.

Joseph

[BobWeaver]

Okay, I was thinking that you had a single field with multiple checkbox items rather than several fields with single checkbox items.

I gave a substitute formula in one of the other threads which will convert multiple linebreaks into a single one. Here it is again:

Substitute(Substitute(Substitute(Substitute(MyInputText,

"