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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Phone list reports - Multiple categories 4
Create a macro to eliminate certain words from several columns 4
Group Header with Multiple Keywords 6
Help - I Need Excel VBA Help With Sorting and New Worksheets 6
Tallying selections from adrop-down box 5
combine worksheets and populate fields 1
Update Query to remove Text before "=" 4
append query if form item is null 0

Back
Top