Re: Setting up a report that won't print empty fields

Getting close...

I turned the label into a text box and set can shrink to yes...
I took your formula and inserted my field name to get the following:

=IIf([Consumer Data Sheet] Is Null,Null,"Show this text")

but all I get is #name? on the report, and it shows even though there is no
data.

I followed your directions to a T on a few fields and had the same prob.

What did I do wrong?

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200512/1
.

Relevant Pages

  • invisible labels when theres no data
    ... this with the text box set to "can shrink". ... is the label. ... Prev by Date: ...
    (microsoft.public.access.reports)
  • Re: export report to word
    ... but a ZLS will shrink a text box the same as Null ... I think the core issue here is that the "label" text boxes ... >testing) and in the report details properties. ...
    (microsoft.public.access.reports)
  • Re: Access, hide blank fields AND Captions
    ... You can shink the labels of you change them into text boxes, and set their ControlSource so they shrink when their "attached" text box is null. ... This example shows how to shrink the label that was attached to the City text box: ... When I print my report it has more blank fields than not, ...
    (microsoft.public.access.reports)
  • Re: Best chart format to use?
    ... abandon the positive/negative display and just go for a stacked column chart with the Rec and Prob adding up to "Response". ... create a second stacked bar series which simply copies the "Prob" column, format it to be invisible and format its data label to be "Inside Base". ... Third option is to change the chart type of that series to "Line" instead of "Column" type, and format the data label to be "Below". ...
    (microsoft.public.excel.charting)
  • Re: Cables
    ... and thought of wrapping *tape* (poor man's laminate) over them. ... the problem that you need to label before final assembly though. ... I then tried wrapping with clear tape. ... Shrink tubing eliminates the end problem -- but requires access ...
    (comp.arch.embedded)