validation rule for ISBNs

[ADKO]

Hello all,
I am currently creating a library database but am struggling with trying to create a validation rule for a field that is to hold ISBNs. I need a rule that accepts only valid ISBNs.
Secondly I am entering the ISBNs via a barcode reader which always has 3 numbers before the ISBN code is there any way of formatting this entered number so that it omits these first three numbers?
Thank you
ADKO

 

[NOL]

Hi,

For your first question :
You would want to know the definition of a "valid ISBN" before creating a rule to validate it ...

and for your second..
if your ISBN is always of fixed length say 10 chars,
you can use -- Right( trim([ISBN]), 7)

or if you don't know the length ---
Right ( [ISBN], Len(Trim([ISBN]))- 3)

You can create a new table with the updated ISBN codes or update the existing table..
post back if you need help


Gina

 

[jfgambit]

According to the Access help files:

ISBN 0-&&&&&&&&&-0

is the Validation Rule for ISBN...

Just a thought.