Report Draw Reference for Access
Access reports don't have to be boring lists of numbers, they can come to life with drawings. Here is a web page with my notes as I was learning about drawing on Access reports. It has syntax, values, and explanations. I hope it will be a good reference for you too.
Report Draw Reference
https://msaccessgurus.com/VBA/ReportD...
00:00 Access Report Draw Reference on MsAccessGurus.com
00:06 Access reports come to life with drawings
00:11 web page with syntax, values, and explanations
00:30 Maybe you haven't thought about Access as a drawing tool
00:34 ... you'd be surprised at what Access can do
00:41 Quick Jump is a fast way to look up Methods, Properties, and Functions.
00:46 The main methods are Line, Circle, and Print.
00:52 Properties affect how the methods behave.
00:56 Useful functions to calculate position and set color.
01:03 LINE The Line method can do more than draw a line.
01:13 The line can be solid or use a different style.
01:17 Lines can be boxes.
01:23 show indicators, progress, and meters
01:28 snowflakes
01:31 CIRCLE Circles can look like the moon
01:34 You can draw whole circles, parts of circles, and arcs.
01:39 Fill with color and patterns.
01:42 Rainbows, clocks, trees
01:47 Specify Aspect to draw an ellipse, or oval.
01:52 PRINT Print is to write text.
02:00 Periodic chart, shortcut keys, atoms ... to heavenly bodies.
02:09 COMBINE Line, Circle, and Print to make complex drawings
02:14 Dials and Meters, Stoplights, Calendars, Snowmen
02:26 Look up the Line method
02:36 If B or BF is specified, the line becomes a box
02:46 Intellisense doesn't work for Line or Circle.
03:00 There's a link to the Microsoft Help page for Line
03:11 syntax and a brief description of each parameter
03:40 FillStyle
03:53 DrawWidth
03:59 DrawStyle
04:13 DRAWING REFERENCE link tells you where drawing with VBA works,
04:21 Order of Events
04:35 These VBA examples draw circles, lines, and boxes in lots of different ways.
04:52 If you can imagine it, Access can probably do it.
Contact me for training ... Access, Excel, Word, PowerPoint ... and drawing with VBA
kind regards,
crystal
Let's connect and team-develop your application together. I teach you how to do it yourself.
https://msaccessgurus.com