Grouping Combo Box Doesn't Show All Fields

[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)

 

[Duane Hookom]

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.

 

[boyratchet via AccessMonster.com]

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?

 

[Duane Hookom]

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.