Annoying behavior in Access 2003 report design view

[DougP]

Annoying behavior in Access 2003
In a report if I need to make a formula in a text box in the control source such as
=IIf([Sa]=0,"",[Sa]) .
The field in the Table happened to be Sa

Then I change the "Name" of the text box to Saturday otherwise an error is thrown because it doesn’t recognize the control source.

When I hit the save button it changes all the formulas to
=IIf([Saturday]=0,"",[Saturday]) which is the new Name and then every place Sa was used on the report is changed to Saturday as well. Of course it happens to all the text boxes and there could be dozens.
So then I have to change it all back again.
This is VERY F…. Annoying and REALLY pisses me off, since I sometimes spend a tremendous amount of time getting it all right in the first place. I only notice this when I view the report and it propmts for "Saturday" or something
I know there is probably not a fix since Office 2007 is out.


DougP
< I Built one

http://www.robots2000.com

 

[dhookom]

This is the reason why one of the first tasks in creating Access apps is to turn off all Name AutoCorrect garbage. [tt][blue]Tools->Options->General[/blue][/tt] and uncheck all Name AutoCorrect boxes.

Duane
Hook'D on Access
MS Access MVP

 

[DougP]

Never knew it existed.
When I un-checked that and click OK I get a prompt about taking a few minutes and closing everything to update.

What all is that going to change? There might be a feature I love or use that will suddenly quit working?

DougP
< I Built one

http://www.robots2000.com

 

[dhookom]

IMHO, unchecking the options will fix your MDB. I believe that leaving them checked will allow you to change an object name and it will cascade to all other references. I find this very dangerous and undesirable.

Duane
Hook'D on Access
MS Access MVP