Code

[Azeez_Andaman]

Hi everybody

how to remove blanks from code

i am trying to write code for a programme. in the programme users have to enter their code to identify them before entering other details. there is a chance to enter blanks in between or at the start or end of the code. some may try to create duplicate code by giving blanks before or after the code. to prevent such deliberate or inadvertent entry of blanks i tried to write code in "before update" to validate these code, but it is not working properly.

can you help me to write code for the purpose.



thank you.

[RuralGuy]

Look in help for the Replace() and Trim() functions.