Empty fields in Access reports

  • Thread starter Thread starter Mary
  • Start date Start date
M

Mary

Does anyone know of a way to hide fields that have no data
in a report like WORD does in a merge. Some of the records
have data in the field and they need to print. Some
records do not have data and they leave an empty space on
the report--these I'd like to "hide". Would like some
feedback. Thanks.
 
Set the CanShrink property of the control to Yes. This will allow the control to shrink
down to zero height if there is no data. There can be no other control or object on the
report that is horizontally in line with the control you want to shrink except for the
control's label, if it is bound to the control (i.e. it moves when the control is moved).
 
Mary,

Another way to manage address type blocks is to use the +
sign which conditionally adds characters to your control.
See the example below. The chr(13) and chr(10)
only "appear" if the other field has data.

=[first name] & (Chr(13)+Chr(10)+[address line 1]) & (Chr
(13)+Chr(10)+[address line 2]) & (Chr(13)+Chr(10)+
[locality]+" "+[state]+" "+[postcode])

The can shrink is not always the best way to go.

HTH,

Terry
 
Back
Top