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
 
You must log in or register to reply here.

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

Access compare fields in a table 0
If Empty/null field, hide label (?) 2
Open report from multivalue fields 1
Test for empty field in a DAO Recordset 6
total cost on report 4
Help with VB Access Function for a Report 1
How to hide a text field label when the field is null? Access2003 3
How can I hide empty fields in a report in Access 2003? 1

Back
Top