Thank you for your post.
You are on the right track. Create a second layout, and replace the field labels with calculation fields. For example, a second street address field may or may not contain data. The field may be called "Street 2" and the field label would display "Street 2". Instead, create a calculation field, "Street2label", with the formula:
If ( IsEmpty ( Street 2 ) ; "" ; "Street 2" )
That is, if the contents of the field are empty, then display nothing. Otherwise, display "Street 2".
Does that make sense?
Now, you have a decision to make... Do you want blank space on the form where the "Street 2" fields displays? Or, do you want the City field (and State and Zip) to slide up and take the place of where the "Street" previously displayed?
If you want the former, you don't have to do anything.
If you want the latter, perform the following steps:
1. Pull down the View menu and select "Layout Mode".
2. Pull down the Edit menu and select "Select All". This selects all objects on the layout.
3. Pull down the Format menu and select "Set Sliding/Printing..."
4. Check the option "Sliding up based on", and then select the option "All above" or "Only directly above"; depending on your preference.
5. Click "OK", pull down the View menu and select "Preview Mode" to see how this will print out.
Let me know if you need clarification for any of the above steps.
Hi and thanks!
And thanks for writing out all that explanation. I'd all but got there but didn't want to go doing that to 50ish fields - if there was infact some hidden little button or script or thing somewhere that I couldn't find that actually just did that
but - as there's not I'll get on with it.
I read the pages on sliding etc in the book - figured this might be where it would come in useful
Thank you.... hopefully - fingers crossed, this is it, I don't think there is anything else left to ask :smileyhappy: