Required field property is not listed (1 Viewer)

[bdhtexas]

We just upgraded to Access 2003 and I am creating a new database and in my Form... I was trying to set the REQUIRED FIELD PROPERTY to YES, but when I click the Properties of each field, it's not listed.

Has this been removed?

 

[Jonathan Kok]

'Required' is set at the Table level, not the form level. You can use validation on the 'before update' event in its place.

 

[GohDiamond]

Check this information regarding the REQUIRED PROPERTY
http://msdn2.microsoft.com/en-us/library/aa196551(office.11).aspx

 

[bdhtexas]

I ended up adding a code to check all the required fields before updating, it's working nicely. Thanks!