I am trying to show the month, i.e., "Jul" in a report based on a field with
a value of "07"
using   =format ("07", "MMM")  in the text box, it shows Jan, not July.
what is wrong?  thanks!

How can I check the status (visible or hidden) of a field before apply
the setfocus on that field ?
I've now a setfocus on a field that could be hidden. If hidden I want
to set the focus on another field.

I have a database of issues based on a template. I have changed some
field names throughout the database, for instance "Status" has become
"IssueStatus."
I am working on a report of open issues, but I keep getting prompted

I have created several reports that has a total in the header of each report.
What I would like to do, if possible, create a new report consisting of only
the header information from each report.
Each report header has the PO #, Projected Total, Leasestartdate,

I'm want to create  a function in Visual Basic .NET (framework 2.0) that can
check if report has landscape orientation or portrait. So far I only know how
to get hold of the report. Some thing like this works fine:
Dim report As Access.Report

Let me try to explain my problem.
I just create cross tab and he shows all expenses quarterly.
I create report based on inputs from that cross tab.
All inputs were, not correct ones, just for testing.

A few months ago, something changed on one computer where a large database
resides.  When we view or attempt to print a report on that computer, the
vertical text and data no longer display or print.  Horizontal is fine.  
But, if you go to the other computer, and access that db, ...

To anyone out there...
I have a query where I count the number of Buyers for a specific Auction.
Now in my report, i now need to get the top 5 buyers from each of these 20
auctions. My report is already grouping by "Auction" and "BuyerID" and Would

How do I get the Date Header of a report to repeat on each new page of the
report? A portion of my report falls onto a 2nd page without any
header....just data. Looks odd and difficult to read. Thanks in advance.

  I run a store procedure in my SQL backend which return information to my
access front end through a recordset. How can I "transform" this recordset
into a report? For what I've been reading it seems that you can't use a
recordset as a recordsource!? would it be possible to ...

I have a table with customers and orders.  It looks something like:
Date / Customer / Order
1/07 / James / Stapler
2/07 / James / Paperclips

I have a report which I need to distribute to others.  Some may have Access
installed others may not.  
I see I can export the report to Snapshot viewer format.  
1.  Is there a Microsoft link I can send people so they can easily download

I'm working on making a custom report in Access and am having trouble
formatting some numbers that are in text fields.  The report was started with
the report creating wizard and modified to meet customer requirements.  
Access used text fields to sum a few of the fields (i.e. Jan ...

Very strange. I have a report that has a subreport. It previews just fine,
including the subreport, but when I then send the preview to the printer, I
get this error: "This expression is typed incorrectly, or it is too complex
to be evaluated..."(blah,blah,blah)

I have a form with a text box (txtbox) and I want to preview a report
showing only records whose ItemDecription begin with the data entered in the
text box.
I have the following code in the "on click" event of the command button that