Hiding form boxes with null values

30 pts.
Tags:
forms
NULL values
Visible
Hello, I have a table that has Name vs F1/F2/F3/F4 and so on. Certain names have a check mark "x" and others do not. I need to be able to pull up someones name and see a summary of what they have "x"'s in. I created a Columnar form that has each name as a seperate sheet; listing all of the F1/F2 etc with X's and null values. The problem is, I don't want to print out a form that has 50 null text boxes. How can I make it so that if an F1/F2 field is null, it won't display itself on the form (or take space)?

Answer Wiki

Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Discuss This Question: 3  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • carlosdl
    Please provide more details. What software and/or programming language are you using ?
    69,605 pointsBadges:
    report
  • Wesleycrozier
    Using Microsoft Access. Not using any programming language. From the research I've done I figure I'll likely need to use Virtual basic to get this done... However, the expressions I've come up with always cause errors or don't work right.
    30 pointsBadges:
    report
  • carlosdl
    You could post your current expressions, and hopefully some Access expert will try to help you. It could be a good idea to create a new question, adding Access as a tag, and including as much details as possible.
    69,605 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following