Custom build your error messages

Figure 1. Which error message would you rather be confronted with?  Access's in-built one (top) or the custom-made one (bottom)? The lesson is, don't rely on inbuilt error messages – create your own so your users are informed rather than bemused.