Charlotte Foust
cfoust at infostatsystems.com
Tue Oct 30 10:07:15 CDT 2007
Have you tried Enabled = False, Locked = True? I don't work with charts on forms, so I'm not sure both properties are available. Charlotte Foust -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, October 30, 2007 7:50 AM To: Access Developers discussion and problem solving Subject: Re: [AccessD] Form Detail Double Click Issue That works but the undesirable side effect is that the background of the chart changes to gray. One idea I came up with was to create an onclick event for the chart that sets the focus back to the first text box that the user can edit the default value in. It might also be possible to set the focus to an invisible dummy text box. -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Heenan, Lambert Sent: Tuesday, October 30, 2007 9:21 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Form Detail Double Click Issue Can you set the chart's Enabled property to False? That should prevent it getting the focus. Lambert -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Kaup, Chester Sent: Tuesday, October 30, 2007 9:42 AM To: Access Developers discussion and problem solving Subject: [AccessD] Form Detail Double Click Issue I have a form with a chart in the detail section. I have discovered that a user can double click on the chart and it can then be edited. I then set the auto activate property to manual which prevents editing the chart but it still gets the focus and the unbound text boxes on top of the chart disappear. Is there some other setting I need to turn on or off so the unbound text boxes remain visible. Any suggestions appreciated. Chester Kaup Engineering Technician -- 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