Rocky Smolin
rockysmolin at bchacc.com
Sat Apr 23 12:57:11 CDT 2011
Bill: Not trying to set the autocorrect options but just trigger the dialog box so that the user can fiddle with it. Apparently, from what I've been able to find on the internets, it works in Excel - there's a constant for it in the Application.Dialogs object. But I can't find the equivalent for Access. Although, IME, anything you can do through the menus you can do through code. Since I can get that dialog box by clicking Tools-->AutoCorrectOptions in 2003 (there's a different sequence of course, in 2007) I'm thinking this has to be doable in code as well. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Bill Patten Sent: Saturday, April 23, 2011 10:33 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Autocorrect Dialog Box Rocky, Does it work the next time you open the app? Some property changes don't take effect while the app is open but do the next time it's opened. Of course if you have set the property back to false on application or form close you will never know. Bill -------------------------------------------------- From: "Rocky Smolin" <rockysmolin at bchacc.com> Sent: Saturday, April 23, 2011 9:16 AM To: "'Access Developers discussion and problem solving'" <accessd at databaseadvisors.com> Subject: Re: [AccessD] Autocorrect Dialog Box Application.AutoCorrect.DisplayAutoCorrectOptions = True Compiles but doesn't show the AUtoCorrect options dialog box. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Saturday, April 23, 2011 9:12 AM To: 'Access Developers discussion and problem solving' Subject: Re: [AccessD] Autocorrect Dialog Box This: Application.AutoCorrect.DisplayAutoCorrectOptions Doesn't work. Invalid use of property compiler error. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of Rocky Smolin Sent: Saturday, April 23, 2011 8:26 AM To: 'Access Developers discussion and problem solving' Subject: [AccessD] Autocorrect Dialog Box Dear List: Does anyone know how to trigger the AutoCorrect Options dialog box from VBA? MTIA Rocky -- 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 -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com