GroupHeader name fields print blank on report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am creating a mailing list which allows me to sort my contacts by group,
however the group names do not actually print (or are at least not visible)
in the generated mailing list. A blank mailing lable spot is reserved for the
group header name, however no name or data is printed.

How can I fix the formatting of this function to allow the group header name
to print above the grouped data?
 
Do you have a text box in the group header that is bound to the group name
field?
 
Unfortunately one was not created when access assigned the Group Header. When
I tried adding a text box in, it was "unbound". Do you know how to link a
text box to the group header?

Thanks for your help!
 
You open the properties of the text box and find the Control Source
property. This should provide a drop down list of all the fields in your
report's record source. Find the group name field.
 
Well...I've tried that...and it seems it would have been the right solution -
however the area designated in the report for this field to print remains
blank. Any other thoughts?
 
If you have a text box in the group header section it should print. Try set
its border to red or another color to see if it shows up. Also set the
background color of the section to yellow to see if it is where you think it
should be.
 
THANK YOU! I finally got it....now I just have one other question.

How can I change the output data from reading the field ID # to the field
name? Is it just a common expression, or a formula within the control source
field that will allow me to do this?

Thanks again!
 
I expect you might have used a lookup field. If this is the case, consider
reviewing http://www.mvps.org/access/lookupfields.htm

You should include the table/field containing the value you want to display
in the report's record source.

You haven't provided any information about your table structures, report's
record source, or table that contains your value you would like to display.
 
Well, Duane! Thank you. You finally got my wheels working, and I realized
that my root query did not use the field name, but the field ID, so I
switched the two and recreated the report, and it's working the way I hoped
(using the text box you suggested earlier!) So thanks again for helping me
through this!
 
Back
Top