Hi All,


Nothing to do with the web.

I am producing a simple data entry form. A column is supposed to take in 9 digits from scan reading students ID cards and storing it.

e.g., if a student ID card contains B000067465-X, I want it to be able to knock off the initial B and the last two digits -X leaving just 9 numeric characters 000067465.

Can this be done at the rule validation table creation level or not. If possible, how?


This would just save me eventually writing VB codes.

Thanks

khronikes

Not, I'm afraid.

Validation only responds to a true or false condition, and the only responses are nothing, or squawk about it.