Runtime-error 2427

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

On one of the reports, users have seen this run-time error several times a
day. After several retry, they eventually will get the report run/printed.
When I went into debug, the break is on the following if statement, which is
the first line of code in Detail_Format()
If CutMethod = "Knife" Then
....
CutMethod is a textbox in the detail session, whose Control Source is a
field from the select statement, which is the record source of the report.
The embedded select statement joins five linked SQL server tables. However,
every time when I run the query, there is always data coming back right away.

I'd appreciate if someone could point me a direction for solving the issue!
 
I avoid putting code in my _Format events unless I have no choice. The reason?
If you're displaying to screen and then to print, _Format events don't always
work the same for both output devices. And when I only print a part of the
report to the printer, I've had very bad experiences. Try cutting (as with a
"Knife", get it?) and pasting the _Format code in the _Print event, and see
if it doesn't work the way you expect.

HTH

(p.s. Sorry for the pun; I couldn't resist.)
 
Back
Top