We have a contacts database of company employees that we print in a layout using sub summaries for each department. Is there a way to make the 'alternative background fill' work in form mode (which we print from)? I can verify the alternative background fill feature works fine if the layout is viewed in Table or List modes, but not in Form mode. This seems rather strange! Why would this feature not carry through to the one mode that surely most use is made of by the people viewing and printing the database? Is this a bug?

How would you have alternate fill in Form view? After all, you only have one record you're viewing.

I mightn't have worded my query correctly, but we've designed a layout, and once it is populated with all the data from the records -not just showing a single record - when you view it in preview mode, or print the layout, the alternative background fill does not appear. However, the alternative background fill effect does appear when the layout is viewed in either list or table views.

Hi Rail, or is that cycle?

Welcome to the Forums.

I think transpower anticipated what you were saying in your first post.

If you are viewing a record in the Form View, there is only one record available, so you won't see a second, third record, etc..

Whereas, viewing records in either list or table will show you a found set of record, so what you described expected behavior.

Lee

It still only shows a single record at a time, regardless of the found set. And since each page contains only one record, there's no need for an alternating fill to distinguish between records, which would be the usual reason for it. I would think you'd only be wasting ink this way.

However, if you really must do it, you'll need a global container to hold the desired color and a calculation of Case( not Mod( Get(RecordNumber); 2 ); globalcontainer ), with a container result. In Layout Mode, copy a box with the color you want, go into Browse Mode, and paste into the global container. Add the calculation field to your layout and make it as large as the desired dimensions. Send it as far back in the layout as you want. Then scroll through your found set. Voila!