Originally Posted by
pbaldy
I'm not clear on the problem. If each field has a textbox to display it, an empty space would be left in place of empty fields. You can use the Nz() or IIf() functions to replace blank fields with something else.
I'm sorry, but my puny little mind cannot fathom this information. I'm still trying to figure this out.
Here is my report setup:
Code:
Family Name: Morgan
First Name: Michael
Address: 415 Jones Street
City: Pensacola
State: FL
Zip: 12345
Home phone: 555-123-4567
Cell phone: 555-446-2345
Emai: mmorgan@yahoo.com
Birthday: 10/17
Spouse: Louise
Birthday: 4-16
Cell phone: 555-446-2317
Email: lmorgan@yahoo.com
Anniversary: 6/21
Child 1: David
Birthday: 4/21
Child 2: Jenny
Birthday: 2/24
Child 3:
Birthday:
Child 4:
Birthday:
I have quite a few single and widowed members who have no ‘Spouse’, ‘Spouse birthday’, ‘Spouse cell ’, ‘‘Spouse email’,
‘Anniversary’, ‘Child 1’ , ‘Birthday1’ , ‘Child 2’ , ‘Birthday2’ , ‘Child 3’ , ‘Birthday3’ , ‘Child 4’ , ‘Birthday4’
Instead of having a lot of empty headers, how can I make the headers not even appear if they are null?