Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to put a rectangle box in a report?

Status
Not open for further replies.

101287

MIS
Apr 8, 2006
189
US
What is the vba code that I can use to set up a block in a section in a report? Or how to put a rectangle in a section in an access report?

Your guidance will be appreciated.

Luis
 
Look at Access help, line method. (Me.Line.....).
There are params for boxes & circles.

Money can't buy happiness -- but somehow it's more comfortable to cry in a Corvette than in a Yugo.
 
Not able to find any help with your recommendation. OR I don't know how to use the help desk. Other suggestions, or can you provide additional example.

Thank you. My apologies but I'm not an expert.

Luis
 
You would add code to the On Format or On Print event of a section like:
Code:
    'Me.Line(X1,Y1)-(X2,Y2), , B
    Me.Line(1000,1000)-(2000,2000), , B
You would need to insert your values for the coordinates. You can also use "Step" in the method to place the X2 and Y2 values in relation to the X1 and Y1 values.

Duane MS Access MVP
Now help me support United Cerebral Palsy
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top