Fieldvalidation

[balooka]

hi

I have a DB where users must enter a serialnumber to track. The number used to be numeric but now theres a letter in front of it (P123456). I do not want to redo all links to a new field. What I would like to see is that the user MUST fill in the full serial (including the letter) and the validation chechs the the first character is a letter and the others are numeric... I've been trying (too) hard to find the solution.

Anyone any hints?

Thx

[BobWeaver]

This function will ensure that the field is exactly 7 characters long, the first character is a letter, and the remaining 6 are digits.

Length(SerNoField) = 7 and Position("ABCDEFGHIJKLMNOPQRSTUVWXYZ", Left(SerNoField, 1), 1, 1) and (TextToNum("1" & Middle(SerNoField, 2, 6))>1000000)

[balooka]

BobWeaver

Thank, works like a charm!

JP