Re: Required Field for 7 Numeric digits only

With the Type:=1, VBA automatically displays a message if the entry is not
numeric, the If statement wouild then force them to make an entry if they try
to bypass by clicking cancel.

But it allows the user to enter a floating point number which the OP apparently does not want.

Rick

.

Relevant Pages

  • Re: Field validation does not kick in
    ... I used the default value property for autonumber generation and the sample ... I generally use the forms BeforeUpdate event to trap for data entry ... This event fires before the data is actually written, and has a Cancel ... Private Sub Form_Error ...
    (microsoft.public.access.formscoding)
  • Re: Field validation does not kick in
    ... I only just require to check and increment the if there is another ... I generally use the forms BeforeUpdate event to trap for data entry errors. ... This event fires before the data is actually written, and has a Cancel ... Private Sub Form_BeforeUpdate ...
    (microsoft.public.access.formscoding)
  • Re: required fields
    ... If you attempt to close the form while some required fields are left blank, ... entry before closing. ... Cancel = True ... error message if they try to close the form without entering all required ...
    (microsoft.public.access.forms)
  • Re: required fields
    ... to prevent Access saving the record if the field is null. ... entry before closing. ... Cancel = True ... error message if they try to close the form without entering all required ...
    (microsoft.public.access.forms)
  • Re: Prevent entering new record thrrough blank entry in Form
    ... This event is always fired once the user has made an entry, ... things are not right, cancel the event, and the record will not be saved. ... For example, a subform should not ... variable in the BeforeInsert event of the form, and cancel the event if the ...
    (microsoft.public.access.forms)