Does not prompt error message when the field is null

[mavisyew]

Hi All,



I have a tbl with some fields which is Required = Yes, Validatetion = Is not Null and Validatetion Text = The field is empty, please enter some value.

There are total around 5 fields with this setting.

I have created a form for the user to enter the fields.

When the user save the entry, they will be prompted if they want to save the change but the system did not prompt the field is empty.

When any fields is empty which is required, and the user select to save the change, the system will not save the changes as the required field is empty.

My question will be how come there is not error message prompt to the user when the required field is empty.

Thanks

[ItsMe]

Are you using VBA or Macros for data validation?

I prefer VBA and will test for Null AND an empty string. Depending on the data type of the field/control, I may test for other stuff.

[Missinglinq]

...When any fields is empty which is required, and the user select to save the change, the system will not save the changes as the required field is empty...

How, exactly, is the user saving the changes? It's not by using a Command Button to Close the Form, is it? The only scenario that I've heard of, where this occurs is if the Form is closed using

DoCmd.Close

It has long been recommended that the code

DoCmd.RunCommand acCmdSaveRecord

or

If Me.Dirty Then Me.Dirty = False

be inserted before using

DoCmd.Close

to close a Form because of a quirk in Access. When DoCmd.Close is used, Access closes the Form regardless of whether or not a PK field has been duplicated, a PK field or other Required Field has been left blank or validation rules have been violated!

If one of these things occur, Access will simply dump the Record, Close the Form, and not tell the user that the Record has been dumped!

The code If Me.Dirty Then Me.Dirty = False or DoCmd.RunCommand acCmdSaveRecord forces Access to attempt to Save the Record, and if a violation has occurred, will throw up a warning message, allowing correction to be made before Closing the Form.

Linq ;0)>