View Single Post
  #6 (permalink)  
Old January 13th, 2005, 09:03 AM
SerranoG SerranoG is offline
Friend of Wrox
Points: 4,007, Level: 26
Points: 4,007, Level: 26 Points: 4,007, Level: 26 Points: 4,007, Level: 26
Activity: 0%
Activity: 0% Activity: 0% Activity: 0%
 
Join Date: Jun 2003
Location: Lansing, Michigan, USA.
Posts: 1,151
Thanks: 2
Thanked 14 Times in 14 Posts
Send a message via ICQ to SerranoG Send a message via AIM to SerranoG
Default

If you still want to avoid code you can open the table in design view. For each field you do not want blank, set the following properties:

Required: YES
Allow Zero Length: NO

Now when the user tries to save a record and move on, Access won't let them. The good news is that no coding is required. The bad news is that Access's built-in error messages are very cryptic. Your users may not understand exactly what the error message is telling them.

Try it.


Greg Serrano
Michigan Dept. of Environmental Quality, Air Quality Division