Prefix in Field

M

May

I have a field that consists of account numbers. Every
number starts with HCT - Example: HCT123, HCT234, HCT345,
etc. How can I set it so if I enter 123, the field is
populated with HCT123?

Thank you and Happy Thanksgiving
 
R

Rick Brandt

May said:
I have a field that consists of account numbers. Every
number starts with HCT - Example: HCT123, HCT234, HCT345,
etc. How can I set it so if I enter 123, the field is
populated with HCT123?

Thank you and Happy Thanksgiving
Click to expand...

If it's *always* "HCT-" then it does not need to be stored. You can simply
set the format property to...

"HCT-000"
 
M

MaRyNa La MeJoR DeL uNiVeRSo... Q'DiViNa SoY!!!

Un caramelito de menta? TE CANTA EL ALIENTO !!!
 
Top