First, I must thank Mr. Lebans for the use of his ReportToPDF function.  It
has worked wonderfully for me.
I have one issue with generating pdf files for legal-sized reports in
landscape format.  Lines, both horizontal and vertical, on the right side of

Group:
I have written an application that previews reports first and then allows
the user to print the report. My problem is that a few of my users have
reported that when they press the button to preview a report they get an

How do I go about displaying the line count of a memo field? I need to
create a report that shows how many lines there are in a memo field for each
record and a total line count at the end of the report. Thanks in advance!!!

This may seem like a dumb question, but here it is.  Is there anyway to set
the default print font and size in a report to save having to change each
individual entry?

I have a text box located in the requred footer section of an Access
report. The formula is: =Sum([Estimated Hour Required]) How can I
calculate this field in increments of 2500?
Basically, if one item on the first page has an Estimated Hour Required

I have a report that currently runs for all dates. How can I make it
that when I run the report, or underlying query, its asks me for which
dates I want the report?

Using the Label Wizard I set up a business card size label and I am
using no record source for this report.  The page setup has two columns
3.5 inches wide and 2 inches high.  I then created a second report with
the page setup two columns 1.5 inches wide and 2 inches high.  I have

I'm having a problem filtering in my report... The code is pasted below. I
thought it would work in 2003 since it works in 2000, but not so. I'd like to
filter the report to show the records for the criteria selected.
Private Sub cmd_PreviewPlanningReport_Click()

I have a subreport that will be showing info from a table. I want it only to
show records that do not contain data in the "Date Stopped" field. In the
subreport properties, I have ([Medication History].Date Stopped Is Null)
entered for the Filter. The Filter On is set to Yes. I ...

I have three fields in the details of a report.  Hrs Wked, Lv Hrs, Extra Hrs.
Each field represents an employee's work schedule for a particular pay
period.  At the Employee Footer of the report, I have a total of Hrs Wked, Lv
Hrs and Extra Hrs.  I now wish to create a text box ...

for various school certificates I have pairs of two separated reports -
front and back (1 and 2). Some users have duplex printers and they would
like duplex printing. Some users don't have duplex printers.
1) Do I have to create 3rd report (for duplex) where page 1 and 2 are ...

I have a database with stations and phone numbers and departments in
one table.  I want to print all the numbers for one department on one
side of a business card, all the numbers in a special group on the
other.  I have used the label wizard but cannot get more than one

I have a situation where each record in the table being reported could
have 0-5 pictures associated with it. I want to print those pictures,
if they exist, with each record's report. I cannot figure out a good
way to do this. I have been attempting to place 5 Image controls in the

I have 2 fields in my book database, Condition and Price. I have the Price
field set as Currency. However when I join the two fields in my report, the
price displays as a number, e.g. 6.5 instead of $6.50. I am using the
expression, =[Condition]&" "&[Price].

I'm not sure where to begin in posting this, because I'm afraid my
"hunches" might lead the reader down a wrong path (since the path isn't
working for me...) but here goes:
I have a report that uses four tables.   The output for the report