evaluate field then label, otherwise slide

[RacingLists]

Hi: I checked my trusty book, 'FileMaker Pro 8 THE MISSING MANUAL', and it's missing all kinds of things.

I have three rows of data in the body - data1 to data3. Data1 always appears in every record and there's a mix of data2 and data3 appearing. I would like to label the data on the same row in the body of the layout only if there is data present. That way, if there's no data, the fields and labels don't print and everything slides up. In the example provided, the calc doesn't work, can anyone help? Thanks in advance! Maybe there's a better way to do this?

Labels.ZIP

[Razumovsky]

Is this for a report? I think you might not be aware that sliding only works in preview mode. Switch to preview mode and see if it is doing what you are expecting.

To do this in browse mode is a much trickier matter...

-Raz

[RacingLists]

yes, in preview mode is what I want to do. I've solved it- sort of - I think - or at least it works. I created a value field with a radio button, label3mark, marked it, and viola. Anyone with an easier way without having to mark the records?

[comment]

You have a syntax error in your calculation. Try instead:

If ( not IsEmpty ( Data2 ) ; "Datalabel2" )

You can also combine all labels in a single calculation field:

"Label 1" &

Case ( not IsEmpty ( Data2 ) ; "¶Label2" ) &

Case ( not IsEmpty ( Data3 ) ; "¶Label3" )

Adjust the field's line spacing to align each label with its data field.

[RacingLists]

absolutely great. Thanks! I'll give it a go.