Conditional Group Footer in a report

[Donna]

I am trying to get a group footer to show or hide based on the value in a
text field [ReqFulfill]. I am using this code (based on a previous
suggestion in this forum)
Me.GroupFooter0.Visible = Len(Nz(Me![ReqFulfill], vbNullString)) ="A"
but I keep getting the error that Access can't find [ReqFulfill]. I know
the name of that field is correct & I have even copied & pasted the name of
the field from the query running the report to the VBA code screen.

Any help would be very appreciated.

 

[Marshall Barton]

I am trying to get a group footer to show or hide based on the value in a
text field [ReqFulfill]. I am using this code (based on a previous
suggestion in this forum)
Me.GroupFooter0.Visible = Len(Nz(Me![ReqFulfill], vbNullString)) ="A"
but I keep getting the error that Access can't find [ReqFulfill]. I know
the name of that field is correct & I have even copied & pasted the name of
the field from the query running the report to the VBA code screen.

Make sure you have a text box bound to the field. Unlike
forms, Access does not load fields that are not used in a
control source somewhere in the report.

The expression:
... = Len(...) = "A"
doesn't make sense. Shouldn't it be more like:
... = Len(...) > 0