Error message "The expression On Format..."

[Meg]

I haven't written an access report in some time and needed to throw one
together today. All was going well until I attempted to build an expression
and I began getting the following error message when I run my report. I
deleted the formulas but am still getting the message. Can anyone please
help me because I am way too far along to start over. Here is the message:

"The expression On Format you entered as the event property setting produced
the following error: The function you entered can't be used in this
expression."

Can anyone give me ideas on how to find where the expression went which is
throwing this report off base please?

Thanks,
Meg

 

[Jeff Boyce]

Meg

If the error message is to be believed, your report has an OnFormat
procedure that includes something Access believes is a function call.

Open the report in design view. Click on the small square in the upper left
corner of the report definition. Click on the Properties toolbar button.
Find the OnFormat property, and open the VBA editor to review the code
behind OnFormat.

You could even add in a breakpoint at the top of the routine, then run it to
learn where Access is choking.

Regards

Jeff Boyce
Microsoft Office/Access MVP