I am designing a report for a chorale group so members can verify or update their information at the upcoming first rehearsal of the new season.
For most members, not all of the fields in the table are populated. i.e. Most do not have a second e-mail, and that field will be blank on the report.
I want a border around each field, whether blank or not, so the member knows where to put in data. For example, they want to list a cell phone that wasn't previously provided.
If I insert a field in the report and format it with a border, only populated fields show up on the report. In other words, a blank field does not show up as an empty box. (Attached "Member Update0.pdf")
To work around this I reformatted all the fields with no border. I then inserted a frame with a border for each field position and put the field inside the frame. As you can see in the attached file (Member Update 1.pdf) the results weren't any better. The populated fields show up properly, while blank fields so not. For all fields except "Email (Secondary)" the frame is only slightly taller than the field. (Frame = .2" field = .187") "Email (Secondary)" frame = .3" and the field is positioned at the top of the frame and slightly to the right of the left frame.
So the question is: How do I get a bordered box for each position of the report, whether the corresponding field is populated?
TIA
For most members, not all of the fields in the table are populated. i.e. Most do not have a second e-mail, and that field will be blank on the report.
I want a border around each field, whether blank or not, so the member knows where to put in data. For example, they want to list a cell phone that wasn't previously provided.
If I insert a field in the report and format it with a border, only populated fields show up on the report. In other words, a blank field does not show up as an empty box. (Attached "Member Update0.pdf")
To work around this I reformatted all the fields with no border. I then inserted a frame with a border for each field position and put the field inside the frame. As you can see in the attached file (Member Update 1.pdf) the results weren't any better. The populated fields show up properly, while blank fields so not. For all fields except "Email (Secondary)" the frame is only slightly taller than the field. (Frame = .2" field = .187") "Email (Secondary)" frame = .3" and the field is positioned at the top of the frame and slightly to the right of the left frame.
So the question is: How do I get a bordered box for each position of the report, whether the corresponding field is populated?
TIA
Comment