hiding blank field in report

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

Guest

Hello,

I have a table with 12 fields.Half of these fields are filled only in due
course of time. Then I wanted a report so I created a querry with all the
fields from the table. Then I created a report linked with querry. Now, the
report both filled and the unfilled fields. I wanted a report with only
filled fields. How to do that? if anyone of you have idea please help
me.Thanks
 
I think you need to be more specific. If a fields isn't filled in, the text
box will not show. Do you wish to hide labels? Are the labels in the detail
section or in a page or other heading?
 
Thanks,

I realised that I was not specific enough. When I creat the report it shows
blank species as well as labels. I dont want both to appear in report when
they are not filled. Labels are in detail section.
 
My favorite method of making a label dissappear is to change it to a text
box and set its controlsource to something like:
="Spouse Name " + [SpouseName]
If the SpouseName field is Null, then the text box will show blank.
 
Back
Top