R
Robert Schuldenfrei
Hi NG:
I solved my own problem. Set up a report the size of which is a letter size
"canvas." Execute a procedure on Report Activation. Have a text box in
each of the 8 printing positions. Define a Select Case switch that will go
to one of eight printing positions depending on the value (1 - 8) of a text
box in the calling form. For example:
Select Case Forms![Contact Entry]!txtPosition.Value
Supose txtPosition.Value was "3" the third case would be:
Me.txt211 = Forms!![Contact Entry]!Name.Value
That would print in the second row, first column on the Avery 9395 label.
That did the trick for me.
Cheers,
Bob
--
Robert Schuldenfrei
S. I. Inc.
3450 So. Ocean Blvd.
Palm Beach, FL 33480
(e-mail address removed)
I solved my own problem. Set up a report the size of which is a letter size
"canvas." Execute a procedure on Report Activation. Have a text box in
each of the 8 printing positions. Define a Select Case switch that will go
to one of eight printing positions depending on the value (1 - 8) of a text
box in the calling form. For example:
Select Case Forms![Contact Entry]!txtPosition.Value
Supose txtPosition.Value was "3" the third case would be:
Me.txt211 = Forms!![Contact Entry]!Name.Value
That would print in the second row, first column on the Avery 9395 label.
That did the trick for me.
Cheers,
Bob
--
Robert Schuldenfrei
S. I. Inc.
3450 So. Ocean Blvd.
Palm Beach, FL 33480
(e-mail address removed)