Drawing a circle on a form

Derek Brown
Derek Brown used Ask the Experts™
on
How do I draw a circle on a form using code?

I Tried this:
Me.Circle (200, 200), 100, 0
But just get error method not found
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®

Commented:
Easiest way to control this, is probably insert a picture instead (as the form doesn't have anything similar, other solutions draws on Windows, not the form perse)
Dale FyeOwner, Dev-Soln LLC
Most Valuable Expert 2014
Top Expert 2010

Commented:
You might want to take a look at this LinkedIn post
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
That's because for that code to work, Me must be a report.

You need tricks for drawing on a form, for example from an old EE post:
Can I draw a circle on a form in Access 2002 using code
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Author

Commented:
Thanks Gustav. Well spotted I asked this question 4 years ago and solved most of it myself. Ended up not using it and forgot all about it.

Kimputer, what do you mean draw on windows?

Dale Link to Linked In does not work for me.
Most Valuable Expert 2015
Distinguished Expert 2018
Commented:
Oh, I didn't even notice you were the asker back then.
Talk about moving in circles.

Merry Christmas!

Commented:
There are some Windows API solution, but they're quite ugly, and draw on Windows itself, not on the form. If you move the form, the circle stays there. Here's on example: https://social.msdn.microsoft.com/Forums/en-US/8c39712f-fb49-4ef6-9fd2-245b79bb6c67/using-gdi-in-excel-vba?forum=isvvba

Author

Commented:
Thanks to you both

Author

Commented:
I do hope points have been allocated this time please confirm and let me know how points were distributed. I have no idea why EE has changed what was a simple easy system for this new one, which is weird.
Most Valuable Expert 2015
Distinguished Expert 2018

Commented:
You are welcome!

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial