Only showing fields with values in?

[nelliott]

Is it possible to display a list that only shows fields in a record if those fields contain values and does not show a blank field if they do not

Hope this makes sense!?

Cheers

Nick

[andygaunt]

Nick,

What type of list are we talking about. A value list or an actual list layout of records?

[danjacoby]

No way to do it in Browse mode; you can use the "sliding/printing" feature to move everything up in Preview mode.

You can also set all the fieldname tags to nonprinting, and create calc fields for each fieldname: If(isEmpty(field), "", "fieldname"). Then put these fields under the fieldname tags -- they'll show up in printing, but only if there's data in the field.

Kinda kludgy, but...

HTH,

Dan

[nelliott]

Andy,

Yes a list layout, not a value list - Dan, cheers for the advice, although not the answer I was hoping for!

[Keith M. Davie]

Have you tried a merge?

[Keith M. Davie]

Or a merge in a portal?

[nelliott]

Could you go into a little more depth - Thanks

[andygaunt]

I think what Keith is getting at is if you use a merge field instead of an actual field on your layout, if there is no data in that field it will automatically slide left, removing the unwanted space.

Simply select the text tool and click on your layout and then choose insert merge field.

The downside of this is the data will be out of alignment with your field names in the header of your list as soon as a record has no data in one of its fields.