Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

null value error

ResolvedVersion 2003

Vinay has attended:
Access Intermediate course
Access Advanced course
Excel Intermediate course
Excel Advanced course

Null Value Error

I have created a number of tables which all have primary keys in them, and have values, but when I go to the form I get an error message saying null values but every entry has a value.

RE: Null Value Error

Dear Vinay

Thank you for attending Access courses. I hope you enjoyed the course and benefited from them.

Does the error appear as soon as you open the form or when you start to enter the data in the form.

Sometimes Null Error also appears if you have set some fields as Entry required to Yes and then leaving those fields blank the records.

I will have to further research into the causes of getting null value error. Once I have found out I'll post a reply!!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000/2003
MCAS Master Instructor 2007

Access tip:

Zoom feature for queries

If youare working on on query design and creating a calculated field, it can be hard to view the whole statement. You can hold the shift key down and press F2, to show the zoomed up version of the query field

View all Access hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.1 secs.