Is there a way to have the user preview a form on a report to verify that
the information is correct and while previewing the report with a command
button have them press another button to send the report to e-mail?
Thank

I have a basic table with a column that produces an auto number. This has
been formatted in the design view at \10000 thus the first record number will
be 10001.
This works and the table shows the number format like this. I have set up a

Can anyone help me with this?  I have a report which contains a level break
on the customer field at which time a new page is started.  Is there an event
that fires on level breaks where I can cause some of the controls on the
report to be invisible only on the first page of each ...

When using the MS Access reports feature of Office Links/Publish with MS
Word, doing so from an Access report, some memo field data gets truncated
with no discernible pattern as to why it happens.
Any solution to this?

I have the following in my report to draw vertical lines
Me.Line (Me.ScaleWidth / 7.4, 300)-(Me.ScaleWidth / 7.4, Me.ScaleHeight)
Me.Line (Me.ScaleWidth / 2.68, 300)-(Me.ScaleWidth / 2.68, Me.ScaleHeight)
Me.Line (Me.ScaleWidth / 2.46, 300)-(Me.ScaleWidth / 2.46, Me.ScaleHeight)

I have designed several reports in access and when i try
to reduce the bottom margin from say 12cm to 4cm, the
program does not accept the change and the report extends
onto 2 pages, vertically. The other margins are top 4cm,

I have used the wizard to define labels in Access and
used the correct label size as listed in access.  It is 3
labels across and 11 down.  When i run the label report,
it only lists 10 down and not 11 as required.  I then

How to make report so that the rows have different color?
For example:
First row have a off-white background color and second row have a white
background color at so on.

I am having a problem where I have a query that runs to create a purchase
order report.  For each line on the PO, a record is queried.  When there are
notes on the PO, there are multiple records queried per line where only the
notes field is changed.  This all works properly but ...

I have a sub report that consists of multiple columns (2
or 3), the data within the parent query is group at only
one level. If I view the output of teh subreport on its
own (not imbedded) it is as it should be, nice neat

I have an ID that is unique that could show 2 times because of locations in
one table. The ID sow in another table 7 times, to record the ID office hours
in the week days. How can I make all these entries in one feild.
Table 1

I can't get the group time to subtotal. This is what I show in my
report:
Group    Date        Start        End    Subtotal
A    2/15/05    10:00 AM         6:00 PM   8:00

I've formed an expression of FamName & DirectoryNames thusly:
[FamName] & "," & " " & [DirectoryNames]
and would like to format the expression in 12-pt and the FamName in Bold
weight, but I can only get the entire expression to appear in Bold.  Is

I have a list of important extended family information that includes
birthdates, anniversaries, etc... that I maintain in Access 2003.  I'd like
to create an access report that prints as a calendar with the event in the
correct block.  I can't figure out how to do this.... can ...

Dear Professionals:
I have several reports which I filter with a query on dates that I print
each Friday. We will not necessarily have entries on each report daily. In
fact, some report will contain for example, entries on Mon. 2/21, Tue. 2/22,