Hmmm,

1. Create an exact copy of the database with a different name (.mdb).............for obvious reasons
2. Open Access, and open the database.
3. Click on the "Tables" tab
4. Select "design view"
5. In the "Table properties" column, right click and check what is in there for "validation rules", "validation text", "filter"
6. At the bottom check out if there is anything in "lookup"

Normally, you create tables or queries, then the forms from them to keep the fields and rules identical.

If I pick the phone number field and put in a space bar
Does that mean if you enter space in the field? or if you put in something like 123 456 789, instead of 123456789?

Can you try <tab> and the arrow keys to exit fields.............."space" is not "null".........it is a value, whereas null is blank?...........that might cause an error?

I will fire up an Office 2000 box tomorrow and get myself a more level playing field.

Let's get it working first, we can beef it up and idiot proof it later..............well that's the way I build them

Cheers