Search results for query: *

Thanks Bob for: DoCmd.SelectObject A_FORM, "frmCallingFormName" DoCmd.Restore I did need to use it after all. Looking at things today I don't understand how I wouldn't have needed it! I previously posted a thread on using custom paper sizes. In Design view, there are only a limited...

Thanks Bob. Strangely enough, I don't need the "Restore" code because the calling form is not Resizeable but it's useful to know. You can tell I've had a long day: my last message should have said "when in Print mode" at the end. John Rose

Immediately after I posted this, I realised that I knew the answer i.e. DoCmd.Maximize in the OnOpen event for the report. However, this then led to another question: when using DoCmd.OpenReport, how can one tell if the report has been opened in Preview or Print mode (in the OnOpen event)? The...

I'm using a DoCmd to OpenReport in Preview mode. Is it possible (in VBA) to open the report as Maximized on the screen? John Rose

In Word 2000, using Panasonic 2130 as the printer (or even the default printer) the Width & Height are shown on the Page Setup dialog box and may be changed. However, Access 2000 does not show them in its Page Setup (for Report Design), let alone allow them to be amended. Does this make the...

I'm using a Panasonic KXP2130 printer and Access 2000 SP-3. I want to use a custom (i.e. user defined) size paper (actually Letter width but half Letter height i.e 8.5" width & 5.5" high). To define a custom paper size: I bring up Design view of the report. I click on File & Page...