Automatically Delete data from certain fields

[pezman38]

I have a table in my Database that uses the feilds Location and partnum. I use a barcode scanner to generate each of these fields. The problem I am having is that when our part number is scanned it contains data such as "des--. 123456 --aa". I have been doing a find/replace on this data to remove the "des--." and "--aa" but I was wondering if access has a function to do this for me so that I can get a macro to check automatically for this type of problem. Any ideas?

 

[Pat Hartman]

If the data is consistant, you can use an update query to update the field. Use the Mid(), Left(), Right(), and InStr() functions to reformat the field.