Share via

Remove Required Field Property

Anonymous
2011-10-25T20:38:45+00:00

I have been toying with Access 2010 Template "Issues Web Database". One thing is driving me nuts. When the status is changed to "Resolved" the resolution field gets set to required. I have looked everywhere for the code or macro that is doing this and I just can't find it. Can anyone help? I do not want the Resolution field to be required ever. Thanks in advance for any help that you may be able to offer.

Microsoft 365 and Office | Access | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

Answer accepted by question author

Tom van Stiphout 40,211 Reputation points MVP Volunteer Moderator
2011-10-26T04:43:48+00:00

It's somewhere on the table rather than the form, as you can see if you try to enter similar data in the table in datasheet view.

To find out where exactly, open the table in datasheet view, select the Table tab from the ribbon, and observe the BeforeChange event is highlighted indicating there is a macro written for it. Click that ribbon button and the code will appear.

Was this answer helpful?

0 comments

1 additional answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2011-10-26T14:39:01+00:00

    Tom,

    Thank you so much. I found and was able to clear it.

    I really appreciate the help.

    Steven

    Was this answer helpful?

    0 comments