Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Aug 21 10:45:22 CDT 2008
I had to make rather complex line and bar graphs once in Access at report time based on data in a table. I used zero length lines positioned where I wanted them and then, in the format event, changed the length based on the bound value from the table. I was also able to position letters like x where I wanted the same way using a known value for the top and left and adding enough twips to put it where I wanted it. HTH Rocky Smolin Beach Access Software 858-259-4334 www.e-z-mrp.com www.bchacc.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Edward S Zuris Sent: Thursday, August 21, 2008 9:34 AM To: accessd at databaseadvisors.com Subject: [AccessD] Drawing on Ms Access Forms Hello Everyone I would like to create a timeline gage where a line shows up on a form to shown that the hours of 10:00 thru 12:00 and 17:00 thru 19:00 are scheduled. I tried a text box, with a string where I could mid$ in various characters an display them in real time, but I am hopeing for a more elegant solution that doesn't look so hoky. Back in the Radio Shack Color computer days you could draw lines on the screen. Using the createcontrol method requires that the forms switch back and forth of design mode. Any ideas on how to get around that ? Any examples I can look at at ? Thanks. Sincerely, Edz. . . . -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com