Solution "Positioning text boxes at run time

  • Thread starter Robert Schuldenfrei
  • Start date
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top