I am trying to format a long string by inserting either a tab character
(vbTab) or a new line character (vbNewLine), depending on data. The string is
in a Variant type variable.  When formatting is done, the result is assigned
to a textbox on a report.

i have a few reports which have been created in landscape but i now need to
set it to protrait. any ideas?
Cheers

Sometimes I need the report itself to control the selection of report
parameters rather than receiving this information from a separate form. To
accomplish this, I want to launch a form from the On Open event of a report
itself. The form should pop up allowing the operator to ...

I have a query set up that feeds a report with several
fields...  I have the query set up so that it pulls
records within a certain date range.  One other parameter
is the "department" from which the information is

I have a tif image that is 29k but when I put it into an Access 2000 report
the database grows by 9mb.  Is there a better way to insert an image that
maintains the quality and keeps the database size smaller?
Thanks for your help!

I am trying to place an image in a series of Access 2000 reports.  I've tried
as .bmp, .jpg and .tif and get basically the same result each time.  The
original image is quite small, but when inserted into the report, the
database size dramatically increases.  (like from 3mb to ...

On my report there are two fields that gets it's data from a single List Box.
Is it possible to indicate in two different Report fields which column from
the List Box I want to show.
Thanks

Hi, I need to create a monthly report. before open, it will ask for input
month, then open report based on that month. I have no idea how to do that,
anyone can help?
Thanks!

I have a query based form with the unbound ComboBox Customer Name and
other bound fields from joined tables. I would like to add a option
group with several choices like First Notice, Second Notice, Final
Notice.

I have a text box that is bound to a field and a text box
that is not bound to a field in a report. i want to make
them top align (verticle alignment). i right-clicked on
the text boxes and went to the align menu on the cascade

I have 2 subreports in a unbound main report. Each subreport has total in
its footer.
I would like to sum up the two totals in the footer section of the main
report.

I would like to open a report and then view it before sending it to e-mail.
Here is the code I have it opens the report but sends the report straight to
e-mail. How can I change the code to view the report first and then send it
to e-mail.

The report below was output using sendobject using rtf ans the output type.
The dates under REPORT  and before Supervisor are not part of the report.
They Just Appear. Any suggestions or answers?
MERIT/PERFORMANCE  REVIEW  REPORT

I am trying to get text boxes to display all the data entered into a Memo
field.

I have a once-working Dlookup that has decided to quit.  Here are the
particulars:
tblTransactions
LinkField (PK, autonumber)