Script stating exact no. of characters reqd.

[Graham A]

I have a field in my database into which a bar code number must be typed. The number is always 13 characters long I want to attach a script to the submit button that basically says if there are less than 13 characters or more than 13 characters in this field flash up a message saying "the bar code must be 13 characters long".

I'm sure it's dead easy but I can't seem to fathom out the steps or language I need to use.

Heeelp

Graham

[snekkis]

Hi Graham,

This worked for me:

If [" not Length(yourfield)=13"]

Show Message ["The bar code must be 13 characters long"]

Exit Script

End If

[LaRetta]

Hi Graham,

You don

[Lee Smith]

You can do that using field validation. Check out the options behind the field in Field Definations, and use by calculation Length(Names) = 13 check the box for strick, and type in your message.

HTH

Lee

[snekkis]

Thanks you guys, I learned something new too!

Snekkis