Unanswered: Error message for required entry on form
Hi, I am a relatively new Access user and am probably over my head with this question.
I had to design a database (for my job) that will be used for others to enter data in a form. One of the entries is required - they can use a drop down arrow to select or enter text. I left the default as blank because they might just accept the default and not really answer (they are really not the slugs I'm making them out to be!). Once I selected "required" it won't let them go to a new record without entering sonmething, however the error message is too cryptic for most of the users.
Is there a way to edit the error message? Otherwise, I've been trying to use the expression builder (with onkeypress and linking it to that field). However I didn't know how to get it to recognize if a field "is blank" or how to get the message to pop up afterward. I've used the macro builder (in telling the form to always open to a new record), so I could try that but I having problems with the conditions again. I want the message to come up if they click through and leave the field blank.
Yes, you should enter the entire phrase (without the parentheses, of course). It should work regardless of whether the combo box is bound to a field / query or unbound. Try clearing any Default Value setting you have for that field. You also may want to try changing the properties of the field itself in the table Design View. Try switching the Required property to Yes and the Allow Zero Length property to No. You can even put a Validation Rule / Text on the field itself there, instead of the form control. One of those should work.