Hi All,

I am wander how can I write a case statement for something that I don't want to show the return blank space if no record in one of the following field. Any help will be good. Thank you in advance.

<>

<>

<>

<>

<>

Select the fields in Layout Mode, Main Menu >> Format >> Slide/Printing. Then Select the Slide Up.

This will only be seen in Priview Mode and when printed.

HTH

Lee

Hi Lee,

Thank you for the help. I guess I was not that clear on the post. What I am trying use the send e-mail from Filemaker but I need to have a calculation if in case I have an unused field inserts still cause a carriage return, so we have all 

this blank space before the paragraph. How can I write a calculation to avoid the blank space if in case no data into the field. Any help will be appreciated. Thank you in advance.

PhP

Post a copy of your calculation than.

A simple method:

Case ( not IsEmpty ( MondayTODO ) ; MondayTODO & ¶ ) &

Case ( not IsEmpty ( TuesdayTODO ) ; TuesdayTODO & ¶ ) &

...

Case ( not IsEmpty ( FridayTODO ) ; FridayTODO & ¶ )

A more sophisticated method can be found here.

And if we wait until the person post their calculation, we can be more specific.