Primary Keys Numbers and Characters

[Chip1035]

This is what I'm trying to do:
One field which is a File Id # which contains numbers and letters
When I save the record I get the error "File Number Must Only Contain Digits."
This is the setup:
The field in the table is set as a primary key and the data type is set as
Text.
The table is linked to another table that has the same info. I did not
create this database & it's fairly complete except we need this field to
include letters & numbers.

 

[Chip1035]

Forgot to mention, using Access 2003

 

[Larry Linson]

This is what I'm trying to do:
One field which is a File Id # which contains numbers and letters
When I save the record I get the error "File Number Must Only Contain
Digits."
This is the setup:
The field in the table is set as a primary key and the data type is set as
Text.
The table is linked to another table that has the same info. I did not
create this database & it's fairly complete except we need this field to
include letters & numbers.

Text fields can contain either numeric characters or alphabetic characters.
If, in fact, the error message and field names are correctly quoted, that
message is not generated by Access.

First, look for a field in the record named "File Number". Access would not
"translate" File ID # to File Number.

Look in the BeforeUpdate event for the Form, or in the Validation property
for the field in the table or the Validation property for that control in
the Form. The inherent restrictions of the field type are not the only
restrictions that can be put on a field.

Larry Linson
Microsoft Office Access MVP

 

[Chip1035]

The table field name is "fileno" with the caption "File Number"
There is nothing in the beforeupdate field.