nelliott Posted March 5, 2002 Posted March 5, 2002 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 Posted March 5, 2002 Posted March 5, 2002 Nick, What type of list are we talking about. A value list or an actual list layout of records?
danjacoby Posted March 5, 2002 Posted March 5, 2002 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 Posted March 5, 2002 Author Posted March 5, 2002 Andy, Yes a list layout, not a value list - Dan, cheers for the advice, although not the answer I was hoping for!
nelliott Posted March 6, 2002 Author Posted March 6, 2002 Could you go into a little more depth - Thanks
andygaunt Posted March 6, 2002 Posted March 6, 2002 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.
Recommended Posts
This topic is 8285 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now