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

[karateka.returns]

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.

 

[Duane Hookom]

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

 

[karateka.returns]

I thought of doing that but i cant make the filter i have applied to
the forms translate into a report.

 

[Duane Hookom]

I expect someone here could help you if they knew more about your filtering.

 

[karateka.returns]

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.

 

[Duane Hookom]

This sounds interesting but it isn't too helpful.

 

[karateka.returns]

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.

 

[John W. Vinson]

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]

 

[Tom Wickerath]

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]

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

 

[Tom Wickerath]

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
__________________________________________