If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
|
Thread Tools | Display Modes |
#11
|
|||
|
|||
Setting up a report that won't print empty fields
Gosh, these expressions just aren't working. All I get is #name?.
I made sure that the Name property is not the same as any other fields, but its still not working. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200512/1 |
#12
|
|||
|
|||
Setting up a report that won't print empty fields
Start from the simple, and build up.
Can you get this working: =[Consumer Data Sheet] If that works but the IIf() does not, I guess you could have a problem with a missing reference: http://allenbrowne.com/ser-38.html -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jenni Grubb via AccessMonster.com" u16268@uwe wrote in message news:583e2521e487c@uwe... Gosh, these expressions just aren't working. All I get is #name?. I made sure that the Name property is not the same as any other fields, but its still not working. |
#13
|
|||
|
|||
Setting up a report that won't print empty fields
I can't even get =[Consumer Data Sheet] to work. I looked at the link
regarding references, but the files I need were checked. So I don't have a clue at this point. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200512/1 |
#14
|
|||
|
|||
Setting up a report that won't print empty fields
In that case, it seems that you do not have a control on your report named
Consumer Data Sheet Perhaps it is named something else? Perhaps without the spaces? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jenni Grubb via AccessMonster.com" u16268@uwe wrote in message news:586f47691967f@uwe... I can't even get =[Consumer Data Sheet] to work. I looked at the link regarding references, but the files I need were checked. So I don't have a clue at this point. |
#15
|
|||
|
|||
Setting up a report that won't print empty fields
Ok, after taking a break from this horrible report, I went back and redid
every step in a new report. It seems things are better, however the "show this text" part of the formula in the quazi-label is not showing up, so when I do have data that needs to appear, only the data appears and no label. Thanks for being patient with me. I think we've almost got it now. -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200512/1 |
#16
|
|||
|
|||
Setting up a report that won't print empty fields
Debugging can be fun. ;-)
(Well, it can be frustrating anyway.) Here's another version you could try: =IIf(Len(Nz([Field1], "")) = 0, Null, "Show this text") -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jenni Grubb via AccessMonster.com" u16268@uwe wrote in message news:58d6877815ef0@uwe... Ok, after taking a break from this horrible report, I went back and redid every step in a new report. It seems things are better, however the "show this text" part of the formula in the quazi-label is not showing up, so when I do have data that needs to appear, only the data appears and no label. Thanks for being patient with me. I think we've almost got it now. |
#17
|
|||
|
|||
Setting up a report that won't print empty fields
Eureka! It works... Now I just have to do the rest of my 60 quazi labels.
I do have one more question though. Since I had to put each control on a separate line, is there a way to set the report to print a record on one page only, even though the report setup is two pages long? Because the fields shrink, I don't need a record to report on two pages... one with data, the other blank. Actually the records can print one right after the other on page if the record data is short enough to share a page. Is that possible? -- Message posted via AccessMonster.com http://www.accessmonster.com/Uwe/For...ports/200512/1 |
#18
|
|||
|
|||
Setting up a report that won't print empty fields
The default behavior is to print on the one page.
Perhaps you have set some sections Force New Page property? -- Allen Browne - Microsoft MVP. Perth, Western Australia. Tips for Access users - http://allenbrowne.com/tips.html Reply to group, rather than allenbrowne at mvps dot org. "Jenni Grubb via AccessMonster.com" u16268@uwe wrote in message news:58e006f4e63d6@uwe... Eureka! It works... Now I just have to do the rest of my 60 quazi labels. I do have one more question though. Since I had to put each control on a separate line, is there a way to set the report to print a record on one page only, even though the report setup is two pages long? Because the fields shrink, I don't need a record to report on two pages... one with data, the other blank. Actually the records can print one right after the other on page if the record data is short enough to share a page. |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Printing Reports Access 2002 Pleas Advise | Dermot | Database Design | 12 | October 5th, 2005 11:23 AM |
how do I not print blank fields in access report? | David | Setting Up & Running Reports | 1 | February 22nd, 2005 03:21 PM |
Still Hoping for help with a Query problem | Don Sealer | Using Forms | 15 | November 13th, 2004 06:24 AM |
How do I print the details view | David | Running & Setting Up Queries | 5 | August 28th, 2004 12:17 AM |
Label | SRIT | General Discussion | 2 | June 22nd, 2004 09:42 PM |