Re: Please HELP - Forms 4.5

On 13 Nov 1997 15:36:25 GMT, sander smit <sander.smit_at_cmg.nl> wrote:

>Why not make the fields mandatory (using the field property)?
>

That is only tested at record validation time, not item validation time.

>am_balshem_at_fccc.edu (Andrew M. Balshem) writes: > We've a very simple forms 4.5 application (10 fields). ID and SPECIES
>> fields cannot be null. I've a trigger on both fields to make certain
>> that neither are null.. When I enter the form my first enterable
>> field is ID and the cursor is placed there. If I click anywhere
>> prior to entering the ID I receive an error (that I must enter ID) as
>> I should. However, after I've entered ID if I use my mouse to skip
>> over the SPECIES field I don't get a similar error unless I've first
>> entered the SPECIES field. I've tried using each of the WHEN-MOUSE...
>> triggers to no avail. I do have a pre-insert/update trigger that
>> checks that both fields are not null & these do prevent commiting bad
>> data to the database. I would, however, like to write a trigger to
>> immediately inform the user that SPECIES cannot be null whenever
>> they've used a mouse to skip over the field. Any solution?
>

--

Alex Heney,  Global Villager

Remove NO and SPAM from the above address if replying by email.