Show error message to user if incorrect amount of numbers entered

B

Baz

Hi there
On the data base you have to enter a seven digit part no
code, it then searches for the record. Is there anyway I
can show a message if not all seven digits are entered.
Some part nos are only 5 digits but the the lookup table
has them in this format e.g. 0012345, if the user only
enters 5 digits it does not find it. Or alternativly is
there away to automatically insert zeros if the user
inputs less than seven digits. Hope this all makes sense.

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top