Grouping Combo Box Doesn't Show All Fields

  • Thread starter Thread starter boyratchet via AccessMonster.com
  • Start date Start date
B

boyratchet via AccessMonster.com

I have a report bound to a query, but when I attempt to add a grouping level,
all the fields in the query are not listed in the combo box. Any ideas?
(Using Access 2007)
 
What are the field types of the ones that are not listed? You can't group on
a memo field either in a query or in a report.
 
It's just a text field.

Before having this problem, I had changed the query upon which the report is
based; that is, I changed the actual query, leaving the record source
property of the report untouched. Now it looks like it is refusing to update
the grouping combo box. I have tried changing the record source to other
things, and the grouping combo box updates accordingly, but when I change it
back, the fields listed are still those from the query before I changed it.

I thought about deleting the query and starting over or changing its name and
setting the record source property accordingly, but while I was fumbling
around, I tried setting the group level to an expression, i.e. the field on
the query I was trying to find. This seems to work. Would I have any reason
to think otherwise?
 
There shouldn't be any issues with entering a field name from your report's
record source as long as it isn't memo or possibly some other non-standard
field or field name.
 
Back
Top