Setting required field property

[brbarto]

Is there any reason the Required property in the field properties needs to be set to Yes for the primary key?
Does it matter? It appears that if a field is the primary key, it is required, but the Required property is not automatically changed to Yes?

Thanks

 

[tlbroadbent]

Access will not allow a null Primary key column. Setting the Required property will validate data as the user leaves the column. The Primary key contraint is enforced when the record is saved. So it all depends on how you want to handle validation. Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.