If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Access report question
How do I create a circle around some text on an an Access Report?
|
#2
|
|||
|
|||
Access report question
|
#3
|
|||
|
|||
Access report question
"Marshall Barton" wrote: Mary Ann Mary wrote: How do I create a circle around some text on an an Access Report? Use the report's Circle method in the section's Print event. How do you plan on calculating where the center of the circle should be? I'll need more details if you want example code (which is likely because the Help topic is more than a little garbled). As an aside, it might look nicer if you draw an elipse instead of a circle. -- Marsh MVP [MS Access] The text I'd like to circle (stored in a label) has a left property of 3", a top property of 7.7917", a width property of .7917" and a height property of ..2917". |
#4
|
|||
|
|||
Access report question
Mary Ann wrote:
"Marshall Barton" wrote: Mary Ann Mary wrote: How do I create a circle around some text on an an Access Report? Use the report's Circle method in the section's Print event. How do you plan on calculating where the center of the circle should be? I'll need more details if you want example code (which is likely because the Help topic is more than a little garbled). As an aside, it might look nicer if you draw an elipse instead of a circle. The text I'd like to circle (stored in a label) has a left property of 3", a top property of 7.7917", a width property of .7917" and a height property of .2917". Try this: With nameoflabelcontrol Me.Circle (.Left+.Width/2, .Top+.Height/2), .Width/2+50, _ vbBlack, , , 0.4 End With Play around with the 50 and the 0.4 to get it to look nice. The 50 is sort of a margin and the 0.4 makes a medium flattened ellipse (1.0 makes a circle). If you want to change the width of the line, use: Me.DrawWidth = 10 ' or some smallish number before the above lines. -- Marsh MVP [MS Access] |
#5
|
|||
|
|||
Access report question
Thank you very much for your help.
"Marshall Barton" wrote: Mary Ann wrote: "Marshall Barton" wrote: Mary Ann Mary wrote: How do I create a circle around some text on an an Access Report? Use the report's Circle method in the section's Print event. How do you plan on calculating where the center of the circle should be? I'll need more details if you want example code (which is likely because the Help topic is more than a little garbled). As an aside, it might look nicer if you draw an elipse instead of a circle. The text I'd like to circle (stored in a label) has a left property of 3", a top property of 7.7917", a width property of .7917" and a height property of .2917". Try this: With nameoflabelcontrol Me.Circle (.Left+.Width/2, .Top+.Height/2), .Width/2+50, _ vbBlack, , , 0.4 End With Play around with the 50 and the 0.4 to get it to look nice. The 50 is sort of a margin and the 0.4 makes a medium flattened ellipse (1.0 makes a circle). If you want to change the width of the line, use: Me.DrawWidth = 10 ' or some smallish number before the above lines. -- Marsh MVP [MS Access] |
Thread Tools | |
Display Modes | |
|
|