Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > comp.databases.ms-access > #14086

Re: MS Access Report - Print Preview Issue

Show all headers | View raw

It could be that every computer has a different 'default' printer.


<internet.shopping@foobox.com> wrote in message
news:361e9b4f-e08c-45cd-be1b-d00346996099@googlegroups.com...
Do you have the relevant printer driver installed on the machines where the
problem arises?

Jim

On Friday, 8 May 2020 08:29:49 UTC+1, rama  wrote:
> On Thursday, May 7, 2020 at 6:39:08 PM UTC+3, Patrick Finucane wrote:
> > On Thursday, May 7, 2020 at 4:57:49 AM UTC-7, rama wrote:
> > > On Thursday, May 7, 2020 at 7:34:19 AM UTC+3, Patrick Finucane wrote:
> > > > On Wednesday, May 6, 2020 at 12:54:44 PM UTC-7, rama wrote:
> > > > > I have developed an MS Access 2016 database report, which has got
> > > > > some 150 text fields and two sub reports. This report is opening
> > > > > in report view and displaying data properly except date fields.
> > > > > However, it is not displaying anything in print preview. Initially
> > > > > the report was working fine, later it stopped. The select query,
> > > > > which pulls data form the table is okay and displaying data
> > > > > without any problem. I am looking for some kind help urgently as
> > > > > the project to be submitted soon.
> > > > > Thanks in advance.
> > > > > Rama
> > > >
> > > > Throwing mud at the wall, hoping something sticks.
> > > >
> > > > Are all date fields blank or just some in your report?
> > > >
> > > > In your date field property sheet for Format see if mm/dd/yyyy makes
> > > > any difference.
> > > >
> > > > Maybe try opening the the query as a recordset.  Then ensure the
> > > > date field is a date.  Let's say your field is called startdt, then
> > > > do a
> > > >   msgbox isdate(r.startdt)  'r being  the recordset variable.
> > > > and verify the field really is a date field.
> > >
> > > Apology for making misunderstanding.
> > >
> > > Mentioned report is setup to print in A3 size paper and default view
> > > of the report is Print Preview. When I open the report, it does not
> > > show anything in the page, even the labels for the text boxes, just
> > > blank page. Also, it is worth to mention that the report has more
> > > pages, although it is setup for one page. I have tried to save this
> > > blank preview as .pdf file, but .pdf output file is corrupted.
> > >
> > > Due to the above-mentioned scenario, I have tried to open the report
> > > in Report view to see what happens. For me I do not need to open it in
> > > report view. I am only interested in Print Preview.
> > >
> > > Thanks for the reply
> > > Rama
> >
> > Still tossing mud at the wall.
> >
> > First, open your report in design mode.  Select the report and
> > subreports and shrink the width by an inch on the right.  I have a funny
> > feeling your report is too wide for the paper size and is screwing up.
> > Then run.  Does that improve the report?
> >
> > Next, create a new report with the query as the recordsource.  Add only
> > a few fields to a report, mostly date fields.  Run the report.  Is it
> > OK?
> >
> > Next, if all else fails, recreate the report.  Stop/start/run the report
> > as you recreate.  See if you get better results.
>
> Thank you so much.
> I have copied the same database in another desktop and the report is
> opening in Print Preview without any problem. Later I tried the same in
> another eight desktops, but found the above-mentioned trouble in two
> desktops. Remaining six desktops it is working fine. I have no idea why
> the report is behaving in this way as in all desktops MS Access-2016 is
> installed.
>
> Any suggestion, advice highly appreciated.
> Rama

Back to comp.databases.ms-access | Previous | Next — Previous in thread | Find similar | Unroll thread

Thread

MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-06 12:54 -0700
  Re: MS Access Report - Print Preview Issue Patrick Finucane <patrickfinucanetx@gmail.com> - 2020-05-06 21:34 -0700
    Re: MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-07 04:57 -0700
      Re: MS Access Report - Print Preview Issue Patrick Finucane <patrickfinucanetx@gmail.com> - 2020-05-07 08:39 -0700
        Re: MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-08 00:29 -0700
          Re: MS Access Report - Print Preview Issue internet.shopping@foobox.com - 2020-05-08 04:21 -0700
            Re: MS Access Report - Print Preview Issue "Phil Hunt" <NoOne@Nowhere.com> - 2020-05-08 13:25 -0400
              Re: MS Access Report - Print Preview Issue rama <chanattu@gmail.com> - 2020-05-11 12:16 -0700
            Re: MS Access Report - Print Preview Issue "Phil Hunt" <NoOne@Nowhere.com> - 2020-05-08 13:26 -0400

csiph-web