<div>
Select the field on your report and right click-Properties. Goto &quot;Can Shrink&quot; property and set it to &quot;Yes&quot;. When the field is empty it will hide the field. Repeat for each field.<br />
<br />
jppinto<br />

</div>


Select the field on your report and right click-Properties. Goto "Can Shrink" property and set it to "Yes". When the field is empty it will hide the field. Repeat for each field.

jppinto


<div>
Thank you jppinto. &nbsp;This did work for the field, but not the label. &nbsp;Am I missing something?<br />
<br />
Terry
</div>


Thank you jppinto.  This did work for the field, but not the label.  Am I missing something?

Terry

<div>
You did not specify how your report was designed?<br />
<br />
Can you post a screenshot, so no guesswork is required?<br />
<br />
jppinto's post will hide the &quot;textBox&quot;/Field, as you requested.<br />
<br />
You did not mention any labels in your original post, you only used a generic term of:<br />
&nbsp; &nbsp; Not showing empty &quot;Fields&quot;<br />
<br />
;-)<br />
<br />
JeffCoachman<br />
<br />

</div>


You did not specify how your report was designed?

Can you post a screenshot, so no guesswork is required?

jppinto's post will hide the "textBox"/Field, as you requested.

You did not mention any labels in your original post, you only used a generic term of:
    Not showing empty "Fields"

;-)

JeffCoachman



<div>
Thanks all for your posts - sorry it has been a while since I posted back a response.<br />
<br />
Regards<br />
Terry
</div>


Thanks all for your posts - sorry it has been a while since I posted back a response.

Regards
Terry

<div>
<div class="content wysiwyg-content">
Hi Experts,<br />
<br />
I have a report that has 4 fields on it. Some of the records contain information within each field, and on other occassions there is only information in 1, 2 or 3 of the fields. &nbsp;When I run my report, for each record I only wish to show the fields that have data in them and not the empty fields.<br />
<br />
Is this possible, and if so, can anybody help?<br />
<br />
Thank you<br />
Terry
</div>
</div>


Hi Experts,

I have a report that has 4 fields on it. Some of the records contain information within each field, and on other occassions there is only information in 1, 2 or 3 of the fields.  When I run my report, for each record I only wish to show the fields that have data in them and not the empty fields.

Is this possible, and if so, can anybody help?

Thank you
Terry

Access reports - handling fields with no data in them

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.