limiting data in a field

[jamccarley]

I have a database that tracks all of the parts we place on hold. One of the
fields contains the lot number of the parts. There is only suposed to be one
lot per record. I have limited the text to only allow 7 caracters and I
cannot take that any lower. Is there any way to add a validation rule that
will not allow a comma in the field?

 

[John W. Vinson]

I have a database that tracks all of the parts we place on hold. One of the
fields contains the lot number of the parts. There is only suposed to be one
lot per record. I have limited the text to only allow 7 caracters and I
cannot take that any lower. Is there any way to add a validation rule that
will not allow a comma in the field?

NOT LIKE "*,*"

 

[jamccarley]

Such a simple solution, Thank you so much.