# Field Validation

**URL:** <https://www.dynamicsuser.net/t/field-validation/9307>\
**Category:** Developers Forum\
**Created:** [October 28, 2004, 11:42am UTC](https://www.dynamicsuser.net/t/field-validation/9307 "2004-10-28T11:42:31Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![vikasshettar](https://avatars.discourse-cdn.com/v4/letter/v/e274bd/32.png) [@vikasshettar](https://www.dynamicsuser.net/u/vikasshettar)\
**Post date:** [October 28, 2004, 11:42am UTC](https://www.dynamicsuser.net/t/field-validation/9307/1 "2004-10-28T11:42:31Z")

</div>

Hi, I have created a field called “Test” in customer table which is also displayed on the customer card. Whenever an user accesses the customer card & creates a new record he should mandatorily enter the value in the “Test” field. To do this i have enabled the “Not Blank” of this field, but it did’nt work. Please help me in this regard Thanks & Regards, Vikas

---

<div class="post-metadata">

**Author:** ![Viktoras](https://avatars.discourse-cdn.com/v4/letter/v/e68b1a/32.png) [@Viktoras](https://www.dynamicsuser.net/u/Viktoras)\
**Post date:** [October 28, 2004, 11:58am UTC](https://www.dynamicsuser.net/t/field-validation/9307/2 "2004-10-28T11:58:43Z")

</div>

Hi, as I know, this isn’t simple task. Property “Not blank” works good for primary key fields, in other cases it works only when user wants to delete value. One of the solutions could be to create new form with field “Test”, which is called from insert trigger. You then can check if the field is filled or not and do not let then user leave this form until the field is filled. Regards, Viktoras

---

<div class="post-metadata">

**Author:** ![Nelson](https://avatars.discourse-cdn.com/v4/letter/n/dec6dc/32.png) [@Nelson](https://www.dynamicsuser.net/u/Nelson)\
**Post date:** [October 28, 2004, 12:28pm UTC](https://www.dynamicsuser.net/t/field-validation/9307/3 "2004-10-28T12:28:38Z")

</div>

See these topics: [http://www.mbsonline.org/forum/topic.asp?TOPIC\_ID=12014&SearchTerms=mandatory,field](http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=12014&SearchTerms=mandatory,field) [http://www.mbsonline.org/forum/topic.asp?TOPIC\_ID=645&SearchTerms=mandatory,field](http://www.mbsonline.org/forum/topic.asp?TOPIC_ID=645&SearchTerms=mandatory,field)

---

<div class="post-metadata">

**Author:** ![jsrark](https://avatars.discourse-cdn.com/v4/letter/j/e95f7d/32.png) [@jsrark](https://www.dynamicsuser.net/u/jsrark)\
**Post date:** [October 28, 2004, 4:57pm UTC](https://www.dynamicsuser.net/t/field-validation/9307/4 "2004-10-28T16:57:19Z")

</div>

In GUI the developer must actively manage data validation. IF TEST = ‘’ THEN ERROR(); You can do this in the Table trigger (insert or modify) OR in the Form trigger OnQueryCloseForm Recommended is table but sometimes you must use the form!