P
p96327201
Guest
Hello, please can anyone help???
I have a macro attached to a button which activates a parameter box, in which a postcode (zip code)is entered. If this postcode already exists on my database then the macro does not add a new record and if it doesn't, it adds a new record. Fair enough... The problem is that if someone enters a space between the two elements of the postcode, it doesn't recognise whether this record already exists and will add a new record simply because it has a space in it.
Does anyone know of a way of getting the macro to remove all spaces in a control before it continues to activate? Or any other way around this problem. If you understand what I'm trying to describe...
I would appreciate any help.
Best regards
Rachel
I have a macro attached to a button which activates a parameter box, in which a postcode (zip code)is entered. If this postcode already exists on my database then the macro does not add a new record and if it doesn't, it adds a new record. Fair enough... The problem is that if someone enters a space between the two elements of the postcode, it doesn't recognise whether this record already exists and will add a new record simply because it has a space in it.
Does anyone know of a way of getting the macro to remove all spaces in a control before it continues to activate? Or any other way around this problem. If you understand what I'm trying to describe...
I would appreciate any help.
Best regards
Rachel
