Runtime error 2427 - "You entered an expression that has no value."

[Rowie]

Hi,

I created a report with recordsource based on a query in
Access 2000.

There are 5 levels of grouping in the report. Under
certain conditions, I need to cancel print certain
footers. I try to put in code in the "Format" event of the
footer. I created some controls on the footer sections and
try to refer to the value of the control by referring to
the name of the control. For example,
Control Name : txtGranCode
Control Source : GranCode (a field from the recordsource
query)

In the footer 'Format' event, I put in code:
if UCase(trim([txtGranCode])) like "SCH*" then
Cancel = True
end if

For some reasons, it gives me the above error. Access
seems to have problem with [txtGranCode].

I created some other reports before based on query and
there did not seem to have problem. I would appreciate if
someone can shed some light on this.

Kind regards,
R