Null display if value is $0.00?2456 (3/13/2007 3:13:28 PM) I have a report with multiple rows and columns which takes on sort of a spredsheet appearance. Is there a way to have fields where the value is $0. 00 (currency format) appear as if they're blank? All those 0... Slez
$ needs to go away4127 (3/12/2007 6:43:50 PM) I got a report that already has the $______ My field is currency and diplays $500.00 which is perfect except I dont need both $ signs If I dont use the field the $ still must be there for the contract to be v... Dan
Creating an Event from a report2141 (3/13/2007 1:31:21 PM) Hello, I am trying to create the equivalent of a click-through like we have in an Excel Pivot Table, from an Access report. Does anybody know how to create a OnClick event from a text box or field in an Acc... Utf
Text Box Truncation -- detect it?1332 (3/13/2007 1:28:34 AM) If I put a text box on a report and fill it with text which may be a short line or a long line, and I set the property to CanGrow=No, The short line will fit in the box and the long line will truncate. I expe... William
Inserting a new text box into a report3375 (3/12/2007 12:32:48 PM) Hi, I looked through your forums and didn't see this question answered. Forgive me if it is already there and I couldn't find it. I have a report that I want to add a new text box to. When I create a form th... punter
Marcro to Create PDF from Access Report0637 (3/12/2007 5:55:41 PM) I want to create a macro that fires off once a day to create a PDF file from an access report. How to? ... Utf
Newbie-type question0151 (3/12/2007 4:30:27 PM) Can anyone help me out here? I have a table with a list of entries including a charge ($150). Each entry has a checkbox that indicates PAID - yes/no and another checkbox that indicates "CANCELED - yes/no". I... mdginzo
Reference to Report's System Name1173 (3/12/2007 3:28:35 PM) Pardon me if this is a stupid question, but how do I put the Report's system name in the report? What I want to do is put the report name in the page footer so that if there is an issue with a report, I can ... Jeff
Report not doing what it should.4123 (3/12/2007 11:58:24 AM) Hi, A report has been designed based on a query. When it is run it only throws up one record although there are several that satisfy the query. And it's always the same record. When the query is run it throws ... anthony
I think I got it wrong again.......2178 (3/12/2007 9:38:28 AM) I have a report that I have based on a table. It has been successfully formatted and laid out. Frankly it looked really good. I was very proud of it. It has struck me, however, that I have based it on the table... anthony