[AccessD] Form Field Renaming Itself

Good point.  However, in this case when I changed the Alias in the 
combo box to "Order Date" then the source for the  main form field 
was also changed to "Order Date".  Weird.

David

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