Change an O to a 0 on change (1 Viewer)

I have to let go of starting the new records in my database and my OCD alarm is ringing like crazy.

On my record input form there is a field for putting in a PO number (tbl_auditdata - PONumber) and typically the PO number looks like this: P0FG456. At this time there is always a P for the first character. Also at this time the second character is either a T or a zero and the rest of the characters change constantly. The second character can also change over time but there will never be the letter "O" in the PO number in any position.

I have already put code in the afteupdate event to force capitalization but I do not know how to disallow the letter "O" in this field.

The reason I ask is because through many emails from the database users (who are the ones that will have to create their own new records now), they constantly use the capital O in the PO number when they send me information... so I don't want them to be able to put that in the database to avoid confusion and crappy data.

Please help me with this.

Perhaps you could use the Replace() function. See https://www.techonthenet.com/access/functions/string/replace.php

Input masks are your answer:

https://support.office.com/en-us/ar...ut-masks-e125997a-7791-49e5-8672-4a47832de8da

Bob, I had to give you a thumbs up to get you over the number 666. I’m superstitious that way!

bob fitz said:

Perhaps you could use the Replace() function. See https://www.techonthenet.com/access/functions/string/replace.php

Click to expand...

Replace was the trick

Here is the final code that implements the replacing anything with uppercase and replacing an O with a zero:

Thanks for the responses!