insert a circle to a number

[Mario R. Perez]

Hello Group, A client is asking me if I can insert a Black circle where the line is very wide, (see pics), I tried downloading some fonts types , but I was not successful, some function that in event OnPrint makes the graphic.
thanks for advance

 

[Pat Hartman]

@strive4peace Crystal has done a lot of work with graphic objects. She may be able to offer a solution.

 

[theDBguy]

Are you trying to put a circle on top of a barcode graphic or a barcode font?

 

[Edgar_]

Add an image control and load a PNG circle.

 

[DHookom]

You can use the Circle method of the report object. In the example below, I have a text box named Eggs with a numeric value. I want to draw a red circle around the value if it is less than 50.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    If Me.Eggs < 50 Then
        Me.DrawWidth = 30
        Me.Circle Step(Me.Eggs.Left + Me.Eggs.Width / 2, Me.Section(0).Height / 2), _
           Me.Section(0).Height / 2
    End If
End Sub

 

[Mario R. Perez]

You can use the Circle method of the report object. In the example below, I have a text box named Eggs with a numeric value. I want to draw a red circle around the value if it is less than 50.

Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer)
    If Me.Eggs < 50 Then
        Me.DrawWidth = 30
        Me.Circle Step(Me.Eggs.Left + Me.Eggs.Width / 2, Me.Section(0).Height / 2), _
           Me.Section(0).Height / 2
    End If
End Sub

View attachment 118101

That's what I need, what would I need to make the circle thicker?, Thanks a lot

 

[Mario R. Perez]

Are you trying to put a circle on top of a barcode graphic or a barcode font?

circle the number #26, this can be 1 to 3 digits

 

[theDBguy]

circle the number #26, this can be 1 to 3 digits

Just making sure... The image you posted looked like it was a graphic, and the approach could be different for a graphic than a simple text. For instance, you may have to know the exact position of #26 if it's a graphic.

 

[cheekybuddha]

Here's a link to the help docs for the Report.Circle method that Duane mentions.

 

[DHookom]

That's what I need, what would I need to make the circle thicker?, Thanks a lot

"thick" = "width"

 

[strive4peace]

I love all the drawing capabilities that Access has for reports! and put together an extensive reference page here:

Access Report Draw Reference and VBA Syntax

VBA syntax and explanations for drawing Microsoft Access Reports. Big reference.

msaccessgurus.com

At the top, you can quick jump to general information, Methods, Properties, and a few Functions -- as well as pages with VBA Examples you can try yourself.

Here is my Help for Circle, which has notes so I can use it better myself and also includes a link to the Microsoft help for Circle.

Access Report Draw Reference and VBA Syntax

VBA syntax and explanations for drawing Microsoft Access Reports. Big reference.

msaccessgurus.com

Duane @DHookom has some great examples too.

To draw a circle on top, as a minimum, you'll need a center coordinate and a radius. You can use the boundaries of your image control to figure those out ... but how to tell if the image is too wide? and what would be the position? Do you have a way to logically determine that?

Before the circle is drawn, you can set (for the Report object) DrawWidth, ForeColor (which I forgot to mention here! since you can optionally set Color to override that), DrawStyle, FillStyle (0 for Transparent), etc

Note that the Circle method can be used to draw circles with different (or no) fill color and outline, as well as arcs that are filled or not, and ellipses

 

[strive4peace]

ps, @Mario R. Perez , in case you don't know how many digits there will be ... perhaps you want to use Line instead of Circle? And possibly draw more than one line? Right boundary and Top? possibly also Bottom line? but you don't want lines to cover your data!

However, it looks like there is enough space to make a Circle/ellipse enclose more space to the left

 

[Mario R. Perez]

ps, @Mario R. Perez , in case you don't know how many digits there will be ... perhaps you want to use Line instead of Circle? And possibly draw more than one line? Right boundary and Top? possibly also Bottom line? but you don't want lines to cover your data!

However, it looks like there is enough space to make a Circle/ellipse enclose more space to the left

Thank you very much, Very useful information and examples, Mario