Hiding form boxes with null values
Home > IT Answers > SAP > Hiding form boxes with null values
Wesleycrozier
30 pts.
0
Q:
Hiding form boxes with null values
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)?
ASKED: Apr 28 2009  9:42 PM GMT
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _
RELATED QUESTIONS
0
Wesleycrozier
30 pts.
0
A:
 RATE THIS ANSWER
0
Click to Vote:
  •   0
  •  0
  • AddThis Social Bookmark Button
Last Answered: Apr 28 2009  9:42 PM GMT by Wesleycrozier   30 pts.
  •   
0
0
RSS - Discussions Help
Discuss This Answer:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _



_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

Carlosdl   29855 pts.  |   Apr 28 2009  9:57PM GMT

Please provide more details.
What software and/or programming language are you using ?

 

Wesleycrozier   30 pts.  |   Apr 28 2009  10:42PM GMT

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.

 

Carlosdl   29855 pts.  |   Apr 28 2009  10:54PM GMT

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.

 
0