I have a table that has
Name F1 F2 F3 F4
Bob x x
Mark x x
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 Ie.
Wes F1 <Blank box> F2 "x" F3 <Blank Box> F4 <Blank Box>
Next sheet has Bob etc
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 up space on a printed copy)?
I have been playing around with visual basic with the following equation:
If IsNull(F2) then me.F2.Visible=False Else me.F2.Visible=True EndIf
But when I do this, the form comes up as normal with blank boxes included...
As a side note:
When I click the empty F2 box, edit it, delete everything (returning it to null), and click outside I get the error "You cannot hide a field that is the focus".
I'd appreciate any assistance, thanks!