How do,
I have a form that outputs addresses in a format that can be printed on to 3x7 label paper for envelopes.
What I want is a way to enter blank (or " ") rows to the query result where the user specifies so no label is printed in that particular place.
I am aware of the problems of inserting blank records to tables. I say this as the other forums I have searched all reply with disbelief and condemnation for inserting blank rows into a database rather than offering support to the question asked.
I am not trying to store the blank rows, just insert them into the Report's record source at user specified intervals.
For example, the rows populate the labels as such:
Row 1 | Row 2 | Row 3
Row 4 | Row 5 | Row 6
etc
If there is no label in the space Row 3 would be printed on, I want to be able to output the rows as:
Row 1 | Row 2 | BLANK
Row 3 | Row 4 | Row 5
etc
Is there anyway of adding the blank record in at the correct place without resorting to creating a recordset line by line?
Many Thanks,
NDayave
I have a form that outputs addresses in a format that can be printed on to 3x7 label paper for envelopes.
What I want is a way to enter blank (or " ") rows to the query result where the user specifies so no label is printed in that particular place.
I am aware of the problems of inserting blank records to tables. I say this as the other forums I have searched all reply with disbelief and condemnation for inserting blank rows into a database rather than offering support to the question asked.
I am not trying to store the blank rows, just insert them into the Report's record source at user specified intervals.
For example, the rows populate the labels as such:
Row 1 | Row 2 | Row 3
Row 4 | Row 5 | Row 6
etc
If there is no label in the space Row 3 would be printed on, I want to be able to output the rows as:
Row 1 | Row 2 | BLANK
Row 3 | Row 4 | Row 5
etc
Is there anyway of adding the blank record in at the correct place without resorting to creating a recordset line by line?
Many Thanks,
NDayave
Comment