How to design a report with 4 columns and report header &  
page header/footers should cover the width of A4 paper.
Kindly help.
krish

I am having trouble try to figure out how to create a report from the
following example.  My database has the following fields
FirstName
LastName

I find that I specify margins, paper trays for a report but these are not
remembered consistently.
In most cases, the margins revert back to 25mm and /or tray 2 is selected.
I'm developing on one machine, and my users are on different machines.

I'm trying to use the following code in a text box on a
report but it isn't working.
="This used to work on "& format([createDate],"dd-mmm-
yyyy")

I have used Q207624 and managed to turn off the visability of text in my page
headers and footers on letter continuation sheets. But I am left with a big
spaces. Is there any way I can reset the height of the header/footer when i
turn off the visability of my text boxes. Maybe ...

Hi - I am new to programming in access, although I have several years
programming experience on other platforms.
I have a form with an "Agent Name" combo box and a button that allows them
to run a report by agent.  If the user leaves the "agent name" field blank, I

I have an Access 02 report with an image box called ImageFrame that is linked
to the following code:
Dim picpath As String
Dim sFile   As String

I created an application that fills forms. The form is filled by different
departments that enter their part based on a complex sequence of "invisible"
email that are sent according to which part of the form is being filled. All
users functionnalities are based are based on the ...

How can you format a label to print a full 5 digit zip code with a leading
zero.  I currently link to an excell spreadsheet for this data and it is
formated there with the access special zip code format and shows correctly in
excell.  It appears correctly in the access query, but ...

Is there a way to set an entire row of fields (record) to Visible = False or
fill the fields with color?
For example:
I have a sales report with the Managers info at the top of the report and

I'm working on a report in Access 2003 that should have a header, a grouping
field which is an office name, a list of employees, and then a footer.  The
default behavior of access though is to keep cycling through the data until
it runs out.

I'm trying to run a report that lists the following:
Institution
File Name
File Facts

I have a control on a report where I want to concantenate four text boxes.  
Doing the concantenating is no problem.  I want to put a carriage return and
label between the fields.  For example, what I have now is shown below:
=[COMMENTS] & " " & [CommentsShare] & " " & ...

I'm only printing two fields in a report, but several of the records have no
data in response to these questions; can I format my report so that it skips
records that have BOTH fields empty?  Thanks!

I have labels on my report that are not aesthetically appealing. for
instance a lable may read "Create_Date", but I would like it to read "Create
Date". There are about  60 lables on the report that contains an "_"
(underscore). There could be multiple underscores or none at all. ...