Rocky Smolin
rockysmolin at bchacc.com
Thu Dec 16 23:57:18 CST 2010
I'd try to work around it by renaming the field OrderDate in the table and in the source of the control. Rocky -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com] On Behalf Of David Emerson Sent: Thursday, December 16, 2010 9:08 PM To: Access Developers discussion and problem solving Subject: [AccessD] Form Field Renaming Itself Here is a weird one. Access XP mdb. I have a form with a field called txtOrderDate. The source is OrderDate. Whenever I make a change to the form and save it the source is changed to Date. I can change the source back to OrderDate and save the form OK, but if I change anything else on the form and save it the field source changes back to Date again. Also, if I change the I have cleared all the boxes in the autocorrect feature and this change is not in the lists. Decompile, repair and compact haven't helped. Importing all objects into a new database also didn't help. Any thoughts? Regards David Emerson Dalyn Software Ltd Wellington, New Zealand -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com