Is there any way to stop Access 2000 displaying an empty text box in a report? I've got a report that needs the potential to list 20 different fields of data, but I only want them (the text boxes) displayed if the fields are 'not null'. Any ideas welcome (even delving into VB, though it'll have to be in kiddie language!).

TIA

I drink, therefore I am.

In the Detail section of the report, in the On Format event, do this:

If IsNull(Me.FieldName) Or Me.FieldName = "" Then
   Me.FieldName.Visible = False
   Else
   Me.FieldName.Visible = True
End If

You will need to do this for each field.

Alternatively, you can set the Can Grow and Can Shink properties to yes on each control. I think they will shrink down to 0 twips if they are empty.

Does this help?


mmcdonal

I'll give both of them a go and see what happens. Thanks mate!

I drink, therefore I am.

For checkboxes, if triple state is set to NO, the checkbox will never be null. It is always TRUE or FALSE. For that case, you simply set its visible property this way

Me.chkMyCheckBox.Visible = Me.chkMyCheckBox

If the checkbox is TRUE, Me.chkMyCheckBox is TRUE, and the visible property is set to TRUE. If false, the checkbox will disappear. Use your real checkbox name(s).



Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division

I tried the 'can grow' and 'can shrink' option and they worked a treat. I'll give the code battering a go when I get a chance. Thanks guys!

I drink, therefore I am.