Dialog messages

[raindrop3]

Hello,

I have a little problem: I have a report with data, but the data is somtimes to much (big) for one label. Acces comes up with this stupid message 'Some data may not be displayed.....'

Does anyone know how to disable this 'information dialogs'?

Many thanks! It took me hours and still I haven't fixed it.

Hope some of you guy's can help me...

Greetings,

Albert

 

[Fornatian]

Look at SetWarnings in VBA, seems appropriate here if you don't really want to solve the problem and just want to ignore it.

 

[raindrop3]

Dialog

Thanks for your quick response, but setwarnig wil only prevent the dialog from displaying when I open the report. When I clik on the print button, it displays the warning again. Any ideas how to prevent that?

Many thanks.

Greetings,

Albert

 

[Fornatian]

You need to catch the error number in the button OnClick event which opens the report and deal with it accordingly. Somthing like...

On Error Goto Handler

'your code

Exit Sub:
Exit Sub

Handler:
If Err.Number = 3456 'example only
'ignore
Else
Msgbox Err.Number & VbCrLf & Err.Description
End if
Goto ExitSub

End Sub

 

[raindrop3]

Dialog

Thanks for your answer. But: this dialog isn't an error. It is just an information dialog. So if it isn't an error, I also cannot 'catch' it with an error trapping function. Maybe there is somekind of a function that disables information dialogs, even when I press e.g. the print button.

I appreciate your help very much.

Greetings,

Albert