Need assistance

[JSDART]

Hi
I have built a database and my report layout is fine and exactly as I want it to print BUT when you go to preview or print a message window appears stating "Some Data May Not be displayed" it then suggests going into the report and changing the layout.
I know the report id fine and do not want users going to make any change or to even have to deal with this message box.

Does anyone know how to disable this message box from appearing?
Thanks

 

[Fornatian]

You could use the Report_Error event to trap the error and ignore it

If DataErr = whatevernumber Then
Response = acDataErrContinue
Else
Response = acDataErrDisplay
End If

It is easier in the long run to sort the problem rather than workaround though.

 

[JSDART]

Thanks IAN
Still have a question
The error message box does not give a number.
Where would I find a list of error code numbers.
or do I type the error in quotes.

 

[JSDART]

IAN
I think I found the source the Trappable Microsoft Jet and DAO Errors
is this right?
Thanks

 

[Fornatian]

use Msgbox DataErr to establish the error number.