When-Validate-Item trigger

Hi there

I am trying to put a WHEN-VALIDATE-ITEM trigger on my form to ensure users enter more than 1 character for a persons Initials. Could anyone give me some advice on the SQL syntax for this please.

Many thanks

Joe

Well, I have never used FORMS, but you just need a simple logic,

When length of the contents of field is <= 1 character, throw an error message..

Code:

---

nLen := LENGTH(field_contents);
IF nLen <= 1 THEN
  message ("bla bla..");
END IF;

---

write a compatible code in trigger body or whereever u need..

< 2 will suffice.