required fields question

  • Thread starter Thread starter Steve Goodrich
  • Start date Start date
S

Steve Goodrich

Is it possible to have my own message appear when a required field is
missed, instead of the standard microsoft one (without using vb)

using Access 97

cheers
 
Steve

Instead of setting the Required property of the field to Yes, set the
Validation Rule property to...
Is Not Null
.... and then you can use the Validation Text property to personalise the
message.
 
Steve,
Many thanks for the info, works great,

One more question if I may - When the form is complete there is a command
button called "SUBMIT" which runs a simple macro that, Opens a message box
stating that the form has been completed correctly, the user clicks OK. It
then goes to a new record and sets the focus on the top field "first Name"
ready for the next entry.

If any of the fields that are set to IS NOT NULL have been missed, I get
the message that I have set in the validation text
which is what I want - but I also get two message boxes appear that I assume
are telling me that the macro "Sumbit" has not been executed.
The first error message reads "You can't go to the specified record set" I
click OK
The second Dialogue box Titled ACTION FAILED appears, the macro name
"Submit", Condition true, Action Name Go To record and Arguments ,,new,

Is there a way to Submit the record using the macro without getting the
second two error messages

The same way as when you just click on the record selector at the bottom of
the screen. i.e Validation text box appears, click OK and you are returned
to the form to enter the data in the missed field

Hope this maks sence

Many thanks
Steve
 
Back
Top