Displaying fields with value only

[sahil]

How can I hide empty fields in a report? The table "Batch" which I'm using has the fields "City", "State" and "Province". Now when I pull a report I want the fields which have a value entered in them only to be displayed. That is; if for a particular record; the field "City" and "State" have values in them and the field "Province" is a blank then only "City" and "State" should be displayed and the field name "Province" with a blank value should not appear and the next record should immediately follow without leaving any space. In a nutshell only a field with value should appear on a report otherwise the field with no value
should be hidden. Can anyone help?

 

[ColinEssex]

Why would the 'province' be blank? are there cities and states with no province?

Col

 

[sahil]

Nice take, but this is only a sample database; the fields might not be desinged taking everything into consideration, but a solution to this problem is necessary to go further. Can you please help me out of this scenario?

 

[ColinEssex]

Make the field 'required' and force people to enter a value.

I don't think you will be able to hide a field on a report if some records have a value in it and not others.

Col

 

[Rich]

Set the can shrink properties for the field and detail section to yes