Easiest way might be to set the Required value for that field to Yes in the table design. But this will require every record to have something in the Notes field. You can set the default value to something (ie..<Enter Notes>).
Otherwise on the form, you can also check for a null value in that field if perhaps you need it required in some instances and other instances you don't (ie. if isnull(me!Notes) then....) Where you do this check depends on how the form interacts. If you have a "save" button on the form, you may want to put this code in the OnClick for the save event. Otherwise you can possibly do it in the OnClose event of the form. It's difficult to say where to do the check without seeing the form.
Last edited by pkstormy; 08-03-07 at 14:08.
Expert Database Programming
MSAccess since 1.0, SQL Server since 6.5, Visual Basic (5.0, 6.0)