I have a combobox bound to a field where the Required property is set to
True. When I delete value in combobox field and press enter I get a system
message telling me that I need to have a value in that table and that
tablefieldname. I understand that this state requires a message but is it
possible to supress the system message and instead write my own? And how
could that be done. Appreciate any tips.

regards Hallgeir

Keep in mind that I don't know anything about your tables, relationships and
database when reading the answer below.
It may be easier if you change the table properties for that field in the
table.
Instead of Required = Yes,
Use a validation rule of Is Not Null.

You can usually use the before update event of the form to check for null
values and ask the user to make an entry for those fields.


Jeanette Cunningham MS Access MVP -- Melbourne Victoria Australia


"Hallgeir" <(E-Mail Removed)> wrote in message
news:B136E89E-7093-41DB-AEE0-(E-Mail Removed)...
>I have a combobox bound to a field where the Required property is set to
> True. When I delete value in combobox field and press enter I get a system
> message telling me that I need to have a value in that table and that
> tablefieldname. I understand that this state requires a message but is it
> possible to supress the system message and instead write my own? And how
> could that be done. Appreciate any tips.
>
> regards Hallgeir