Rocky Smolin at Beach Access Software
rockysmolin at bchacc.com
Thu Aug 21 11:31:04 CDT 2008
I don't know how much resizing and repositioning of controls you can do in a form without going to design view. But IIRC, it will work. I know there are lots of properties that can be set at run time like forecolor and backcolor. I'd try it with a simple form with one or two controls. Regards, 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:59 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Drawing on Ms Access Forms Anything like that for interactive forms displayed to the user ? -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Rocky Smolin at Beach Access Software Sent: Thursday, August 21, 2008 8:45 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Drawing on Ms Access Forms 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com