I have a field that has Serial numbers from computer equipment. There are some that the serial number is incomplete. When the tech opens up the form to view the computer information, I would like it to popup a msgbox and inform the tech that the serial number needs completed. This will let the tech then focus on what is missing and hopefully fix it.
I was thinking an IF statement. Here is an example of a serial number
that is wrong and correct:
Wrong: CN-0T6116-71618-123- or
CN-0T6116-71618-
Correct: CN-0T6116-71618-123-A2C3
If it could look for the last 8 characters or last 4 or 5 characters missing that is what I need.
I want to put this on the form where the field resides. So when it loads, it sees the field is missing the values and notifies the tech.
Thanks
I was thinking an IF statement. Here is an example of a serial number
that is wrong and correct:
Wrong: CN-0T6116-71618-123- or
CN-0T6116-71618-
Correct: CN-0T6116-71618-123-A2C3
If it could look for the last 8 characters or last 4 or 5 characters missing that is what I need.
I want to put this on the form where the field resides. So when it loads, it sees the field is missing the values and notifies the tech.
Thanks