Printing non-null fields only in MS Access 2003 report

[yotamoo]

I am trying to generate a report whose source is a form and that only prints fields that are not null.



To do so I have two text-boxes for every field. They are both resizealbe (can shrink/grow). The first text-box is for the caption, and its source is


=IIf([record] Is Null,"","Caption:")

The second is the record value itself. If record is null then the value of both text-boxes is "" and null and they do not appear nor take any space in the form.
Two question:

1. This doesn't seem like the smartest way to do it. Anyone has a better idea?
2. The report also contains check-boxes, and this method only works if I check/uncheck at least one check-box before I generate the report. Otherwise all captions appear anyway. This is very weird - anyone has any idea why it happens?

Thanks!

[stmoong]

1. On top of my head, maybe you can try this with one text box:
=IIf([record] Is Null,"","Caption:" & vbCrLf & [record])

2. Unless your checkbox is tristate, otherwise, it is only True(-1) or False(0) normally.

[yotamoo]

Thanks...
Problem with 1 is that Access thinks vbCrLf is a source, and therefore require a value when I generate the report. Any way to override it?

[stmoong]

Try Chr(10) for new line.

Not sure if this is the best way using string concatenation, it's more of a hack.

[yotamoo]

I'll try it, but in general checking for value and then setting source accordingly is the right way?
Thanks anyway