Age Validation with Message Box

[dolovenature]

Hi,
I am absolutely novice in access, and i am entrusted with a responsibility.
My Problem is.....
I have a FORM(form1) related to a table(table1).
While entering data using the FORM if the AGE field is less than 18 then a Message box would appear "Age is not valid" with only one button is the box "Ok",
If the user click OK it will return to the FORM.
can anybody help with the code?
(Sorry for posting in some other threads...)
Regards


Saikat

[June7]

You could try the ValidationRule and ValidationText properties of textbox.

[Missinglinq]

Or, for a friendlier approach (the Access Gnomes can be very abrupt!)

Private Sub AgeField_BeforeUpdate(Cancel As Integer)
 If Me.AgeField < 18 Then
  MsgBox Me.AgeField & " Is Not Valid Age for this Field!"
  Cancel = True
  AgeField.SelStart = 0
  AgeField.SelLength = Len(Me.AgeField)
 End If
End Sub

Just replace AgeField with the actual name of your 'age' Control.

Linq ;0)>

[dolovenature]

Or, for a friendlier approach (the Access Gnomes can be very abrupt!)

Private Sub AgeField_BeforeUpdate(Cancel As Integer)
 If Me.AgeField < 18 Then
  MsgBox Me.AgeField & " Is Not Valid Age for this Field!"
  Cancel = True
  AgeField.SelStart = 0
  AgeField.SelLength = Len(Me.AgeField)
 End If
End Sub

Just replace AgeField with the actual name of your 'age' Control.

Linq ;0)>

Thanks a lot Missinlinq....
And I am having another problem mentioned at the thred "Ranking Students based on Score & Location and selecting Top three..."

would you please highlight some solution??
Regards
saikat