Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]
Groups > comp.databases.ms-access > #9793
| From | "Phil" <phil@stantonfamily.co.uk> |
|---|---|
| Newsgroups | comp.databases.ms-access |
| Subject | Re: 'Continued' label in Group Header when using Repeat Section - Solved |
| Date | 2014-08-15 09:26 +0100 |
| Organization | Aioe.org NNTP Server |
| Message-ID | <lskg86$q5p$1@speranza.aioe.org> (permalink) |
| References | <00b5fb28-d596-4e1c-ad1e-68dc33078639@googlegroups.com> <lsitav$832$1@speranza.aioe.org> <9f61faf3-9b59-400d-a59c-3a55dac5a830@googlegroups.com> |
On 14/08/2014 23:29:36, wrote: > On Thursday, August 14, 2014 1:57:51 PM UTC-4, Phil wrote: > >> Try this (Sorry, [Type] is the groupheader field name - yes I know Type i > s a >> >> reserved word...) The field Type is Visible = No >> >> the Field TxtTpe is a label >> >> >> >> Option Compare Database >> >> Option Explicit >> >> >> >> Dim HoldType As String >> >> >> >> Private Sub GroupHeader0_Format(Cancel As Integer, FormatCount As Integer > ) >> >> >> >> If HoldType = [Type] Then >> >> TxtType.Caption = [Type] & " (continued)" >> >> Else >> >> TxtType.Caption = [Type] >> >> HoldType = [Type] >> >> End If >> >> >> >> End Sub >> >> >> >> Phil >> >> >> >> --- >> >> This email is free from viruses and malware because avast! Antivirus prot > ection is active. >> >> http://www.avast.com > I liked the idea of trying to use the label's caption to display both the > f ield and the (Cont.) part in attempt to simplify the code, but your code > pu t (Cont.) at the top of the page when it shouldn't be there, plus it > put it in other group headers on the page. Sometimes the group header > format cod e is called more than once and could throw a proverbial monkey > wrench into your logic. Good effort. I'm starting to think the code I > posted might he lp someone :-). > > James A. Fortune > CDMAPoster@FortuneJames.com > Not quite with you then, James. Is this a 2 column report, or single column. Works fine for me as a single column report. With a 2 column report, for example half way down the left hand column, I get “Member” as the group header, and then “Member (continued)” at the top of the right hand column. The “Member (continued) is at the top of both columns on subsequent pages, until the group header changes. Are you saying you only want the “Member (continued)” on the left hand column and blank on the right hand column? Phil --- This email is free from viruses and malware because avast! Antivirus protection is active. http://www.avast.com
Back to comp.databases.ms-access | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread
'Continued' label in Group Header when using Repeat Section - Solved CDMAPoster@fortunejames.com - 2014-08-14 06:55 -0700
Re: 'Continued' label in Group Header when using Repeat Section - Solved "Phil" <phil@stantonfamily.co.uk> - 2014-08-14 18:57 +0100
Re: 'Continued' label in Group Header when using Repeat Section - Solved CDMAPoster@fortunejames.com - 2014-08-14 15:29 -0700
Re: 'Continued' label in Group Header when using Repeat Section - Solved "Phil" <phil@stantonfamily.co.uk> - 2014-08-15 09:26 +0100
Re: 'Continued' label in Group Header when using Repeat Section - Solved CDMAPoster@fortunejames.com - 2014-08-15 06:03 -0700
csiph-web