Fields and labels for null values

[mayday999]

Hi all,

I am putting together a report, is there an easy way to eliminate the field and the label if there is no entry for the field (ie null or empty string) Any help is greatly appreciated!

TIA

D

 

[Remou]

You can set the Visible property in the Detail Format event:

[tt]Me.txtText.Visible=Trim(Me.txtText & " ") <> ""[/tt]

 

[mayday999]

Hi Remou,

This brings me to a couple more questions:

I have alot of fields in this report, about 50, does the line of code need to be inserted for each of the 50 fields? and I want the label gone as well

Next, I am sorry, but neglected to mention, will the fields move upusing this code or will there be a blank line for each field? the blank lines would probably make the report look awkward.

TIA

D

 

[Remou]

That is a little more difficult. You can set textboxes like so:

[tt]=IIf([Field1] Is Null,"","Field1Label: " & [Field1])[/tt]

Which incorporates the label into the textbox. If you make such a textbox quite short/thin, set Can Grow and Can Shrink to yes, and carefully match each textbox border to border, the gaps will close up.