Removing non-alphanumeric characters in an Access Field.

Posted by Jacques Tardie on Stack Overflow See other posts from Stack Overflow or by Jacques Tardie
Published on 2010-03-22T16:44:01Z Indexed on 2010/03/22 16:51 UTC
Read the original article Hit count: 524

Filed under:
|
|
|
|

I need to remove hyphens from a string in a large number of access fields. What's the best way to go about doing this?

Currently, the entries are follow this general format:

2010-54-1 2010-56-1 etc.

I'm trying to run append queries off of this field, but I'm always getting validation errors causing the query to fail. I think the cause of this failure is the hypens in the entries, which is why I need to remove them.

I've googled, and I see that there are a number of formatting guides using vbscript, but I'm not sure how I can integrate vb into Access. It's new to me :)

Thanks in advance, Jacques

© Stack Overflow or respective owner

Related posts about access

Related posts about db