filtering forms

[Ashley]

I have created a database that has some columns that have
no information in them. When I create forms, I would like
to filter out all the boxes with no information on them.

For example:
Joe Smith, sex:Male, City:Toronto, Phone: 555-1234
Jane Doe, sex:Female, Phone 555-4321
Terry Maxwell, City:New York

When the forms are made, I don't want an empty field for
Jane Doe under city, and for Terry Maxwell, I don't want
an empty field for sex and phone. I only want information
to print for the fields that there is info for

 

[Lee T.]

You say "print" so are these forms or are these reports?

If forms and you want to hide the field with no data, you
can do a bunch of IF ISNULL statements, assuming that if
the data is not there you are inserting nulls.

ex: If IsNull(Me!City) Then
Me!City.Visible = False
End If

hth

Lee T.