[AccessD] Form Field Renaming Itself

I learned from this list not to use variable names or aliases that are also
a reserved word.  It makes Access neurotic.

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 11:48 PM
To: Access Developers discussion and problem solving; 'Access Developers
discussion and problem solving'
Subject: Re: [AccessD] Form Field Renaming Itself

I tried that but it still wouldn't work.

But in testing I found that the change was reflecting an alias that I had in
another combo box that was being used to select the record for the main
screen.  That is, I had another combo which had the same table source as the
form source.  When a record is selected in the combo box then the main form
was filtered to only show the same record.  The OrderDate field in the combo
box had an alias of "Date" 
for the combo header.  When I removed the field alias in the filter box then
the problem stopped.  It meant that I also hid the column headers for the
combo box to keep things tidy.  This didn't answer why the combo box should
affect a field property but at least I have solved the problem.

David

At 17/12/2010, Rocky Smolin wrote:
>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
>
>--
>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