Primary Keys Numbers and Characters

  • Thread starter Thread starter Chip1035
  • Start date Start date
C

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 said:
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.
Click to expand...

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
 
The table field name is "fileno" with the caption "File Number"
There is nothing in the beforeupdate field.
 
Back
Top