Hide Record in datasheet

[Guest]

Hello all,

I'm looking for some help in hiding or not showing certain records in a
subform datasheet where one of the control sources in each record is null.

What is happening is that certain controls in some of the records are empty
and it makes it look awful when half of them are null. I would like to
ensure that all control sources have data before showing. If not, then do
not show.

Any ideas how I could go about coding that?

Regards

 

[Joseph Meehan]

Hello all,

I'm looking for some help in hiding or not showing certain records in
a subform datasheet where one of the control sources in each record
is null.

What is happening is that certain controls in some of the records are
empty and it makes it look awful when half of them are null. I would
like to ensure that all control sources have data before showing. If
not, then do not show.

Any ideas how I could go about coding that?

Regards

I am sure there are lots of answers to the question. I would base the
subform on a query and use a criteria statement to limit the records.