Hiding form boxes with null values
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)?
Software/Hardware used:
Software/Hardware used:
ASKED:
April 28, 2009 9:42 PM
UPDATED:
April 28, 2009 10:54 PM
Answer Wiki:
Last Wiki Answer Submitted:
Be the first to answer this question.
All Answer Wiki Contributors:
Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.
Please provide more details.
What software and/or programming language are you using ?
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.
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.