Tags: access, adding, continue, continues, database, dynamically, group, header, microsoft, mysql, oracle, page, postings, sql, text, word

dynamically add "continue" to group header text

On Database » Microsoft Access

1,411 words with 1 Comments; publish: Fri, 06 Jun 2008 11:36:00 GMT; (250249.02, « »)

I have seen great postings for adding the word continue to a group header,

where the group continues on the next page. The problem for me, is the header

text changes in size (number of characters) for each group and the word

"continue" is not properly positioned after my header text. I have found no

way to either change the header text or reposition it.

Any ideas?

All Comments

Leave a comment...

  • 1 Comments
    • Joan Unterweger via droptable.com wrote:

      >I have seen great postings for adding the word continue to a group header,

      >where the group continues on the next page. The problem for me, is the header

      >text changes in size (number of characters) for each group and the word

      >"continue" is not properly positioned after my header text. I have found no

      >way to either change the header text or reposition it.

      It would have helped if you had posted what you currently

      have, but I'll take a guess anyway.

      You probably have a label control with "continued" as its

      caption. then make it visible or not as needed using code

      something like:

      Me.label.Visible = (Me.txtLineCounter > 1)

      If that sort of close, then get rid of the label control and

      delete the code. Then modify the header text box to use an

      expression something like:

      =[headerfield] & IIf(txtLineNum > 1, " (continued)", "")

      Marsh

      MVP [MS Access]

      #1; Fri, 06 Jun 2008 11:37:00 GMT