subform showing no null value

[Mascotte]

Hi

I have a form and a subform is linked to it. The subform is in datasheet view. Does anyone know how to not show null value on my subform?

Thanks.

 

[marianne]

you can customize the RECORD SOURCE of your subform. maybe you can create a query as a recordsource of your subform.

 

[Mascotte]

Hi Marianne,

Can you show me how its done? I am new to Access.

Thanks.

 

[marianne]

i have attached a file here. is this what you mean?

check out the records in the table and records in the form.

you may want to study it.

 

[Mascotte]

Hi Marianne,

Do you think i can hide the fields which has no value? Yours just hide the records.

Pls advise..

 

[marianne]

whats the difference between filtering null value/hiding the records that hiding the fields with no value? does it make difference to your work.

you can set the visibility property of the empty field if that is what you want on_current event.

 

[Mascotte]

What i want is hiding all the fields which have no value and show only fields that have values on them. If i put on the criteria fields the "Is Not Null" condition and the first field is ever null for every record. How do u set visibility propertyof the empty field on on current event?

 

[marianne]

Private Sub Form_Current()
If IsNull(FieldName) = True Then
Me.FieldName.Visible = False
Else
Me.FieldName.Visible = true
End If
End Sub

 

[Mascotte]

Hi Marianne,

I cant seem to get it to work.. there is a compile error message.. i think it has something to do with my field name which is a number. Any idea?