Results 1 to 4 of 4
  1. #1
    New Lounger
    Join Date
    Sep 2004
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Creating sub-headings in a report (Access 2000)

    Is there a way I can add a shaded text box, that will separate my report alphabetically? See attached example

    Thanks
    Nadia

  2. #2
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating sub-headings in a report (Access 2000)

    In the Grouping window of the report, add a line with your name field.
    Set Group Header to yes
    Set Group On to Prefix Characters
    Set Group Interval to 1

    In the Group Header section create a textbox as large as you want.
    Set the Control Source Property enter =Left([NameField],1) <font color=red>with the equal sign</font color=red>
    Set BackColor to 12632256
    Set Text Align To Center
    Francois

  3. #3
    New Lounger
    Join Date
    Sep 2004
    Posts
    6
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating sub-headings in a report (Access 2000)

    Francois,

    Thank you so much. It worked perfectly, however, when I set the Group Interval to 1, it keep the A's together, etc. however they do not stay in alphabetical order. The names move around to An, Al, Au, Ab....

    Any ideas why?

  4. #4
    Gold Lounger
    Join Date
    Feb 2001
    Location
    Sint Niklaas, Belgium
    Posts
    2,778
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Creating sub-headings in a report (Access 2000)

    In the grouping window, add a second line with your NameField in the Field/expresion column and all leave all the other grouping properties to default.
    Francois

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •