Seldom used field showing on reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have an Access database with fields that will in all likelihood remain null
.... but on the off chance that something does make it into these fields I
want this to show on a report. How do I make it that if a field is not null
that the contents are visible on the report and if the field is null then it
doesn't show as white space in my report ...
 
Open the report in design mode.

Add a control to display that field.

Change the control's CanGrow and CanShrink properties to Yes.

Change the CanGrow and CanShrink properties of the SECTION in which the
control is placed to Yes.

DON'T put any other controls directly aligned to left or right.

Regards

Jeff Boyce
Microsoft Office/Access MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Report Query 4
Null fields on report 3
create a report based on conditions 9
Crosstab: <> values not showing 7
Report showing ZLS as null 2
CanShrink question Access 2000 2
Sum Hours over 24 hours in Access Report 0
format phone field 2

Back
Top