After Update add something to the end of a field

S

serviceenvoy

using MS Access 2003
I need to have an "after update" or something similar to automatically
add this text to the end of a field "@mhsfax.com". I want to be able
to enter a number in the field and have @mhsfax.com automatically
added to the end of the number. How do I do this?
 
F

fredg

using MS Access 2003
I need to have an "after update" or something similar to automatically
add this text to the end of a field "@mhsfax.com". I want to be able
to enter a number in the field and have @mhsfax.com automatically
added to the end of the number. How do I do this?
Click to expand...

Code that control's AfterUpdate event:
Me![ControlName] = Me![ControlName] & "@mhsfax.com"
 
S

serviceenvoy

using MS Access 2003
I need to have an "after update" or something similar to automatically
add this text to the end of a field "@mhsfax.com". I want to be able
to enter a number in the field and have @mhsfax.com automatically
added to the end of the number. How do I do this?
Click to expand...

Code that control's AfterUpdate event:
Me![ControlName] = Me![ControlName] & "@mhsfax.com"
Click to expand...

O that is so gorgeous! It works great.
It's nice to be able to find people that simply know how to do these
things. How do I learn to code for myself? I understand basic
software coding principles but I would never know how to write that
line you just gave me. Can you explain it in verbal terms so maybe I
can apply it to other situations?
 
Top