David The best way I think you can have your expression as page header is to make it a section header and set Repeat Section property to Yes. In the report design view right-click on the section header and select Properties. On the Format tab select Yes on Repeat Section. This will repeat the section header on every page. Conditional Formatting: try [Surname] & IIF(IsNull([Forenames]),"", "," & [Forenames]). On Sorting and Grouping enter Surname in the Field/Expression column. Alternatively, concatenate Surname and Forename in the underlying query and group on the resulting field in the report. HTH Liveson _____
From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of David Manders Sent: Tuesday, 01 August, 2006 2:29 PM To: [email protected] Subject: [ms_access] Repeating part of a header only. Hi Gang. I am preparing a printout of music played at a record group and have the following group header for each composer: [Surname] & ", " & [Forenames] which I want to repeat when carried over to another page, and also various other details (birth, death, nationality, etc.) which I don't. So: How do I, in effect, use the < [Surname] & ", " & [Forenames] > as a page header, but also leave it and the other details as a group header? Also, while I am about it, I would also like the < & ", " & [Forenames] > part to be conditional on Forenames having a value, and, in another part of the record I also have a similar arrangement, but in this case either or both parts can have a null value, so the comma sometimes appears in isolation. Can anyone help? Thank you. I hope you all understand what I mean, I am STILL not fully au-fait with all the terminology... [Non-text portions of this message have been removed] Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
