Some data may not be displayed...? 1

[Bobot]

Hi guys -

Hey is there some way in Access 2000 I can turn off the message "some data may not be displayed" when I open a report? I have a main menu with a simple button that calls a Report Preview to print mailing labels, and since everything prints fine on the printer, I would prefer not to mess with the report margins and just somehow disable that dang message!

Any help is greatly appreciated!

- Bob

 

[Beeps]

I think that this is caused by your margins just being a smidge out of the boundary for your page setup.

I know you don't want to, but try saving the report as another and moving the border in question over the smidge.

 

[Bobot]

Thanks!

Yes I did play with the columns, spacing, margins, etc and I can make the message go away, but it doesn't allow me to print as many characters as the setup I had.

It prints fine now, I just wish I could eliminate that annoying prompt.

Something like: accessrpt.prompt.annoying = .false.
to turn that crap off

Hehehe

- Bob

 

[Bobot]

(bump)

Anyone else have any ideas about turning off the message?

Thanks!

- Bob

 

[pdldavis]

Hi, I don't know if this will work for suppressing a print job warning - never tried it, but you might try prior to print:

DoCmd.SetWarnings = False

after print:

DoCmd.SetWarnings = True

 

[pvted]

I marked pdldavis's suggestion as helpful. The method does work except that the syntax is:

before print:
DoCmd.SetWarnings False
...
after print:
DoCmd.SetWarnings True

(No equal signs)
Thanks though - it helped me too.

 

[pdldavis]

Whoops, sorry about the = signs. I didn't know if that would work on print jobs. Useful information. Thanks.

 

[Bobot]

Thanks guys! The SetWarnings thing worked perfectly....

Now was that so hard?