filtering forms

  • Thread starter Thread starter Ashley
  • Start date Start date
A

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
 
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.
 
Back
Top