Conditional Group Footer in a report

  • Thread starter Thread starter Donna
  • Start date Start date
D

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.
 
Donna said:
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.
Click to expand...


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
 
Back
Top