Hide empty field in a report

  • Thread starter Thread starter Willem
  • Start date Start date
W

Willem

In a report in Access 97 I would like to hide a field, named "tussenvoegsel",
in areport if there is no value entered (or Null). So that the empty field wil
not use space on the label.

Greetings and thanks,

Willem
 
in section Format event write:

me.control_i_want_to_hide.visible=not isnull(me.control_with_test_value)

replace names with real
 
Hi Alex,

Thank you for your reply. Sorry, I don't exactly understand what you mean.
Suppose I have the fieldname (control?) with the name 'adres'.

'adres' is a record in the access database. Suppose 'adres' contains no data,
than I would lke to hide the field representing 'adres' on the report in
access. At the moment the empty field allocates room at the print, and that is
what I only want when the record 'adres' contains data.

Greetings and hope to hear from you,


Willem
 
Back
Top