Access '03 Text Wrap print preview (and printer) issue

Whenever I try to print a form, the text box (be it memo or text)
doesn't quite wrap completely in the print preview window, despite
wrapping perfectly in the design and form views.

I have tried pushing in the margins as a temporary solution, but that
hasn't solved the problem at all. I still get half words lopped off by
the printer (and print preview) before the text is wrapped onto the
next line.

0
karateka
8/21/2007 3:00:33 AM
access 16762 articles. 3 followers. Follow

9 Replies
692 Views

Similar Articles

[PageSpeed] 37

Create a report for printing and leave your forms for data entry, navigation, 
etc.

-- 
Duane Hookom
Microsoft Access MVP


"karateka.returns@gmail.com" wrote:

> Whenever I try to print a form, the text box (be it memo or text)
> doesn't quite wrap completely in the print preview window, despite
> wrapping perfectly in the design and form views.
> 
> I have tried pushing in the margins as a temporary solution, but that
> hasn't solved the problem at all. I still get half words lopped off by
> the printer (and print preview) before the text is wrapped onto the
> next line.
> 
> 
0
Utf
8/21/2007 3:06:00 AM
I thought of doing that but i cant make the filter i have applied to
the forms translate into a report.

0
karateka
8/21/2007 3:13:44 AM
I expect someone here could help you if they knew more about your filtering.
-- 
Duane Hookom
Microsoft Access MVP


"karateka.returns@gmail.com" wrote:

> I thought of doing that but i cant make the filter i have applied to
> the forms translate into a report.
> 
> 
0
Utf
8/21/2007 3:46:01 AM
I have applied a filter to the forms such that only certain records
show in the printed version of the form. I only want to print 10 or so
of the 200 records, depending on variable criteria. I have multiple
different filters to apply as need be.

0
karateka
8/21/2007 3:52:49 AM
ok let me try and re phrase by simmilar example.

lets say i am looking at 300 cities with a variety of populations, and
i only want to print out those that have a population of greater than
300,000 ppl OR are greater than 70% of a certain ethnicity OR are
greater than 70% supporters of a local sporting team.

this could result in only having 10 records that meet these criteria
or 250, but i only want to print the records that fit the criteria. I
cant make a report do this, and i am having the above problem when i
use a form to print this kind of enquiry of my database.

0
karateka
8/21/2007 4:10:11 AM
On Tue, 21 Aug 2007 04:10:11 -0000, karateka.returns@gmail.com wrote:

>this could result in only having 10 records that meet these criteria
>or 250, but i only want to print the records that fit the criteria. I
>cant make a report do this, and i am having the above problem when i
>use a form to print this kind of enquiry of my database.

A Report can - and typically would - be based on a Query. If you can create a
query or a filter for a Form, you can use the same criteria for your Report.
Are you assuming that the report must print the entire table!? It needn't.

             John W. Vinson [MVP]
0
John
8/21/2007 5:45:41 AM
There are several methods of creating filtered reports. Two of the easier 
options available include:

1.) Add a command button to your form to print just the active record. See 
this link for more details:

    How to print only one page of a multipage report
    http://www.access.qbuilt.com/html/reports.html#PrintOnePgOfRpt

or

2.) Create a dialog form that allows you to pick various criteria. This 
sample shows how to use a combo box and two text boxes to supply criteria:

   http://home.comcast.net/~tutorme2/samples/customdialogbox.zip

In both cases, you need to create the report first. It needs to include the 
fields that you wish to display.

More advanced techniques, that involve a multiselect list box control, are 
also available.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

"karateka.returns@gmail.com" wrote:

> ok let me try and re phrase by simmilar example.
> 
> lets say i am looking at 300 cities with a variety of populations, and
> i only want to print out those that have a population of greater than
> 300,000 ppl OR are greater than 70% of a certain ethnicity OR are
> greater than 70% supporters of a local sporting team.
> 
> this could result in only having 10 records that meet these criteria
> or 250, but i only want to print the records that fit the criteria. I
> cant make a report do this, and i am having the above problem when i
> use a form to print this kind of enquiry of my database.
0
Utf
8/21/2007 6:26:02 AM
Thanks for your inputs to date, some where more helpful that others.

I have tried working with all suggestions and for various reasons none
have been effective to date.

The most beneficial outcome would have come from the vbasic promt
boxes, however this facility has been disabled in the licence i am
working with.

Does anyone have any other ideas, especialy if it sorts out the first
issue I was having as this reporting is much simpler to train the
aging staff I work with in its use.

Thanks

0
karateka
8/23/2007 2:50:26 AM
Hello -

> The most beneficial outcome would have come from the vbasic promt
> boxes, ...

I haven't a clue what "vbasic promt boxes" (visual basic prompt boxes??) 
refers to. You are using a non-standard nomenclature here.

> ...however this facility has been disabled in the licence i am
> working with.

What software are you using? The subject of this post includes "Access '03", 
so it would appear that you are using Access 2003. Are you attempting to 
modify some commercial software that was released in the compiled .mde form? 
Or, perhaps that has User Level Security (ULS) applied, such that you do not 
have design privileges? Tell us a bit more about what you are using, and the 
license that you are describing.


Tom Wickerath
Microsoft Access MVP
https://mvp.support.microsoft.com/profile/Tom
http://www.access.qbuilt.com/html/expert_contributors.html
__________________________________________

"karateka.returns@gmail.com" wrote:

> Thanks for your inputs to date, some where more helpful that others.
> 
> I have tried working with all suggestions and for various reasons none
> have been effective to date.
> 
> The most beneficial outcome would have come from the vbasic promt
> boxes, however this facility has been disabled in the licence i am
> working with.
> 
> Does anyone have any other ideas, especialy if it sorts out the first
> issue I was having as this reporting is much simpler to train the
> aging staff I work with in its use.
> 
> Thanks
0
Utf
8/23/2007 5:38:01 AM
Reply:

Similar Artilces:

Printing double sided brochures in publisher
I am trying to print a tri-fold double sided brochure in Publisher - my problem is that the 2nd page prints upside down - how do you get both sides of the brochure to be printed the same direction? REDLED wrote: > I am trying to print a tri-fold double sided brochure in Publisher - my > problem is that the 2nd page prints upside down - how do you get both sides > of the brochure to be printed the same direction? If you're manually duplexing: Rotate the second page through 180° before reinserting it into the printer. If you're auto-duplexing: Change the options on ...

Business Portal Error-SQL server does not exist or access denied
Hi, We are running business portal 4.0 for one of our customer. It was running correctly, however, they have changed the SQL server port (previously it was set as default 1433). After that the business portal becomes very slow and while creating a new request (purchase requisition) if we open the item pop up; it is showing exception "SQL Server does not exist or access denied...." Can any body tell me how can I provide the new port number to business portal connection to the database. Thanks and Regards, Waliullah, Thanks for using the newsgroups. I have a...

What's happened to the findfirst function in Access 2010?
I have a working Access 2007 Application which is now failing miserably in 2010. It hinges on location the first available working document in a table runing the following VBA code: With Me.Recordset .FindFirst "([fld1] + [fld2]) = 0" If .NoMatch Then .FindLast "([fdl1] + [fld2]) <> 0" Exit Sub End If .... FURTHER PROCESSING ... What must I do to correct this? Go through a record by record search? End With In 2007, this works correctly, stopping at the appropriate record (approc. rec 1385 in the recordset...

incorrect check / cheque number printing
When generating a cheque run, let’s say cheque 61, 62, 63 and 64, the information printed on cheque # 62 is actually cheque # 64 and vice versa. This does not happen every cheque run, but it does happen fairly often. I have not seen GP do this. What version and service pack of GP are you using? Are you 100% sure the check stock itself is not out of sequence? Do you have any customizations? -- Victoria Yudin Dynamics GP MVP Flexible Solutions, Inc. "Syed" <Syed@discussions.microsoft.com> wrote in message news:3B02ECEF-7436-4CF3-930E-AA4D2DFDF117@microsoft.com... ...

open two different Access reports
Hi, I was wondering if i can get some help here. I have two different reports that i want to open when a user clicks a button to view the reports for printing. Is there any way of popping them up at the same time in VBA? Thank you in advance Associates wrote: >Hi, > >I was wondering if i can get some help here. I have two different reports >that i want to open when a user clicks a button to view the reports for >printing. Is there any way of popping them up at the same time in VBA? > >Thank you in advance Yes. Call the DoCmd.OpenReport command twic...

printing 2 charts on single page
Using Excel 2k, Win 2k I was trying to print to line charts on a single page to demonstrate the corelation between the two data sets. I would like to print in portait mode with one chart on top of page and one on bottom. Excel only seems to offer putting chart 2 on a separate page or embedding it in chart one. I am not very familiar with excel charting capabilites can anyone suggest a resorce? Thanks ...

Access 2007 and Vista code problem
I am developing a database on a XP SP2 machine. On a form I have created some buttons with event procedures that run 2 queries and open a form. I sent the db to someone running Access 2007 on a Vista machine and nothing happens when she clicks the buttons and there are no messages. I know nothing about Vista so thanks in advance for any help. Tim Might be a reference problem, have them open the open a code window and click tools references. See what says missing and tell them what should be there, Add it and it should work. Duff "Tim Reid" <TimReid@discussions.micr...

crm 3.0 error 03-01-06
Hello, I'me getting this error while installing crm3.0 for SBS: "error writing to file microsoft.mshtml.dll verify that you have access to that directory" That file is in the C:\Program Files\Microsoft.NET\Primary Interop Assemblies directory. I (and 'everyone') has full access to that dir. What can I do about this?? kind regards, Thomas ...

Global Column Row Preview Font Size
I know I can change the column, row and preview font size for the current email folder's view, but how do I do it for all of the email folders? I have loads of email addresses each with lots of folders. I don't want to have to do each one at a time. Surely there must be a default font setting (even if it's only in the registry)? Thanks in advance, Tim. I too would love an answer to this. Ian "Timie Milie" <tim_milstead@yahoo.co.uk> wrote in message news:45782ee8$0$27107$db0fefd9@news.zen.co.uk... >I know I can change the column, row and preview font ...

Joining text with a formula in cell #4
just to complete the thread... I found the answer. You have to change the format of the cell to custom 0.00"*" this is the only way it will show only 2 decimal places Thanks for the hel -- Mustard Hea ----------------------------------------------------------------------- Mustard Head's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1630 View this thread: http://www.excelforum.com/showthread.php?threadid=27700 ...

tesuto 03-11-07
tesuto...

Using Access 2003 on client to see Sharepoint 2007
Testing a Sharepoint environment and I can easily manipulate and run the database from Access 2007, but when I try to use Access 2003 it wants me to save the database to a location. The Access 2003 has the compatiblity pack, but it seems to not work when I download it. So the question is using Sharepoint 2007 and posting the Access 2007 format to it, can a user go to the sharepoint site and use a 2003 Access database that has the compatibility pack and open without having to download it? -- Message posted via http://www.accessmonster.com Send check for $500.00 to: David A Jenn...

Comments to print on invoices and packing lists
We have a client with a specific need for printing customer comments and item comments: 1) They want to store comments on Customer Master. When a sales order is entered these comments should default on the sales order with an option to change. They want to mark these comments to be printed on sales order, invoice, packing list and pick ticket. 2) Items are stored with item specific comments. These comments need to come to the sales order when the order is entered with an option to change. They want to setup comments with similar setup where they print on order, invoice, pick ticket and packi...

printing multiple copies of Sigel GmbH
I have made a tent card in a small size of 5.588cm x 4.191cm for a swing tag, using Sigel GmbH in the "other labels" section. It prints one copy perfectly, leaving room on the page for at least about another 5 copies (which is what I want), but when in the print page section it doesn't give me the option to print multiple copies on the page. This will be an enormous waste of paper if I have to print the number of copies individually on each page. HELP! -- candere What is the product number for this label? I cannot find this size label on my 2007 version. -- Mary Sau...

VCard issue #2
This is a weird problem, but when I send a vcard to someone, it shows up in my sent items as a vcf file, and has a vcard icon on it, but when the recipient gets the VCard, it shows up as msg file, with an envelope icon as the attachment. When I open it, nothing is there - it's empty. I can't find anything regarding this problem on google or MS's website. Anybody have any ideas? Is it a problem with Outlook? Do I need to do a detect and repair, a reinstallation? Thanks for your help! Does the same happen when you send a message to yourself? Is he/she able to see it w...

printing imported gif files in Excel
When printing gif file with transparent background on the grey(25%) background of Excel non-transparent part of the picture has white border around it. Is there any way to prevent it? Thank you in advance... Tim ...

parameter for text
In Access 2003. In a form I have a parameter to search for a word at a a time Like [Froms].[Form].txtWords]&"*" which works well. .. In order to enter more than two oarameter separated by commas in txtwords I have been tryin the Str function like this "Instr([txtWords])" "Instr[txtWords]" The query displays no records at all. Could you suggest me how to do it Many thanks I would suggest separating by space and using this -- Like "*" & [Froms].[Form].txtWords] &"*" Remember that when you type in 'bell...

compact database in VBA access 2007
Hello, I have recently upgrade to office 2007 from office 2003. To compact a database from within the database itself, I used the follwing code. Unfortunately it no longer works in access 2007. Is there some similar code that will work? Public Function FncCompactTheCurrentDB() CommandBars("Menu Bar"). _ Controls("Tools"). _ Controls("Database utilities"). _ Controls("Compact and repair database..."). _ accDoDefaultAction End Function Thank You, SL On Thu, 28 Jan 2010 17:34:01 -0800, SL <SL@discussions.microsoft....

attachment previewers not installed?
I have a newly installed Office 2007 and cannot open several attachments ie WMV as I get a message "no previewers installed" How can I resolve this issue? do they open if you double click them? The previewer error is because they can't display (or play) in the preview pane - you need to open the attachment. Are you using Vista or Windows XP? -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: daily...

Merge code issues with Publisher 2003
It seems whenever the data source is altered, the merge code fields have to be reinserted in the Publisher document. Is this normal? The data source starts in Excel and is then saved as a .txt file to retain number formatting on final merge. ...

How do I bind a XAML text box control to a dataset?
Hello; I am new to using WinFx and I am having trouble figuring out how to bind a text box to a field in a dataset. I found an MSDN article: http://msdn2.microsoft.com/en-us/library/ms752057.aspx My question deals with the text box code: <TextBlock Text="{Binding Path=ISBN}" Grid.Column="1" /> How does this text box know to bind to the field "ISBN" in "myDataSet"? How does the control implement the dataset? Thank you Monty ...

LDAP Write access?
My ldap server allows Write access to entries - and a few clients now support this. Any plugins available for Outlook to allow this too? Thanks None that I'm aware of. -- Diane Poremsky [MVP - Outlook] Author, Teach Yourself Outlook 2003 in 24 Hours Need Help with Common Tasks? http://www.outlook-tips.net/beginner/ Outlook 2007: http://www.slipstick.com/outlook/ol2007/ Outlook Tips by email: dailytips-subscribe-request@lists.outlooktips.net Subscribe to Exchange Messaging Outlook newsletter: EMO-NEWSLETTER-SUBSCRIBE-REQUEST@PEACH.EASE.LSOFT.COM Outlook Tips: http://www.outlook...

Creating Text Box in Publisher 2007 Crashes the Application
Hello, we have a clean install of Publisher 2007 under Windows XP SP2, and when we try to create a text box in a document, (both an existing document and a blank document), publisher crashes. Office is fully patched. I ran Office Diagnostics from the help menu and no problems were found and the issue persists. Any thoughts on how to resolve the issue? Thanks, Syd See if selecting a different printer as default helps. How to view error signatures if an Office program experiences a serious error and quits http://support.microsoft.com/kb/289508/en-us -- Mary Sauer MSFT MVP http://of...

Wrap round
How do I get text to wrap round the inside of any shape or text box? I've been to 'help' and followed the instructions but it didn't work! You can add text to a text box from the outset; to add text to an AutoShape, right-click and choose "Add Text." But the included text box will always be rectangular. If by "wrap round the inside" you are implying anything other than straightforward left-to-right text that wraps at the right margin, then you will be disappointed. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alab...

MS Access 2007 code not running
I have created a brand new database in Access 2007 and linked some VB code to run on Form_Load. This code worked perfect with no problems the day I created it. Now today I opened the same form and it is not running the Form_Load code anymore (and yes it is still there, I did not delete it). I got frustrated so I copied and pasted the code to Form_Current and several On_Change events and set breakpoints at the beginning of all the events just to see if it was the Form_Load that was not triggering, but NO events are triggering my VB code. Any ideas? See this page: http://accessjunkie.com/fa...