Change to field name - effects to vb code

[Thwarted]

Hello,
Wondering if anyone knows offhand.
If i were to change a field name on a table - would it automatically be updated throuhgout the VB code in the database?

I am using Access 2002.

Thank you!

 

[xlbo]

Not a definitive reply but I very much doubt it would work like that - You'll probably have to change all references in the code Rgds
Geoff
"Some cause happiness wherever they go; others whenever they go."
-Oscar Wilde

 

[TonyJollans]

Not a chance. Just imagine the havoc it could wreak. Your field name is most likely in SQL in a string. How could Access know what to change.

What it might be able to do in theory, but doesn't, is change the field name where it occurs in Queries, Forms and Reports, but the trouble is that it would be a bit presumptious and not necessarily what one always want.

Enjoy,
Tony