Quick question, I have a table in access where I need to verify if a certain field contains 12 characters, and if it does, cut off the last 4 characters. What would be the best way of doing this using an Access Form?

I tried doing a recordset thing but I'm not sure how to connect to the local provider instead of specifing the file name again.

So this has to be in access, I can't use VB6 for this one (long story)