Validation rule

[ebiscaro]

I can now import data in my table using the transfer spreadsheet macro.

I would like to set a simple validation rule in my Field that contains number to make sure the value entered is really a number and not something else.
Thank you once again for your help!

 

[sparx]

What would you like to do with the number once validated??
ie If the number is not really a number but something else, what do you want to happen?

 

[ebiscaro]

can he read minds?

thank you for your answer,

I would like access to give me an error message and abort the import.

If it is not asking too much Access could ask me to modify the data and the go on.

Alternatively he could skip the record and past it in the paste error table.

I guess the easisest would be the first one.