Welcome to SPN

Register and Join the most happening forum of Sikh community & intellectuals from around the world.

Sign Up Now!

How can i change the message that appears ???

Discussion in 'Information Technology' started by Kimon, Oct 28, 2005.

  1. Kimon

    Kimon
    Expand Collapse
    Guest

    My question is..
    How can i change/or disable the message that appears when a field in a form
    has its property required = true ?
    (When the user update/add a record and this field is null or zerowidth a
    message appears from the access)
    --
    Kimon
     
  2. Loading...


  3. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Kimon,

    In design view of the table, set the Required property back to No, and
    set the Validation Rule property to...
    Is Not Null
    Then you can enter whatever you like in the Validation Text property.

    Only other way to do it is use VBA procedure on the Before Update event
    of your forms to check the validity of the data entered, and display
    your custom messages if not.

    --
    Steve Schapel, Microsoft Access MVP


    Kimon wrote:
    > My question is..
    > How can i change/or disable the message that appears when a field in a form
    > has its property required = true ?
    > (When the user update/add a record and this field is null or zerowidth a
    > message appears from the access)
     
  4. Kimon

    Kimon
    Expand Collapse
    Guest

    I did it but when i add in the subform (continuos form) a record whithout to
    fill the rest fields (required), i focus (click) the previous record and
    nothing happens. The new record that i added has empty fields.
    --
    Kimon


    "Steve Schapel" wrote:

    > Kimon,
    >
    > In design view of the table, set the Required property back to No, and
    > set the Validation Rule property to...
    > Is Not Null
    > Then you can enter whatever you like in the Validation Text property.
    >
    > Only other way to do it is use VBA procedure on the Before Update event
    > of your forms to check the validity of the data entered, and display
    > your custom messages if not.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Kimon wrote:
    > > My question is..
    > > How can i change/or disable the message that appears when a field in a form
    > > has its property required = true ?
    > > (When the user update/add a record and this field is null or zerowidth a
    > > message appears from the access)

    >
     
  5. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Kimon,

    Can I just check here:
    - You have a field where the Validation Rule property in table design
    is set to Is Not Null
    - You enter a new record on the form, and leave this field empty
    - There is no error message when you leave the record?

    If so, I cannot understand why this would happen.

    --
    Steve Schapel, Microsoft Access MVP


    Kimon wrote:
    > I did it but when i add in the subform (continuos form) a record whithout to
    > fill the rest fields (required), i focus (click) the previous record and
    > nothing happens. The new record that i added has empty fields.
     
  6. Kimon

    Kimon
    Expand Collapse
    Guest

    I check it again it works but there is a bug.
    One of the fields in the record is a drop list and it does not work property.
    When the user has focus it and then lostfocus from this field without to
    fill it, the first time it displays the message that i wrote in the
    validatioin text(is not null).
    If the user focus it for second time and lostfocus again from the same field
    whithout to choose somenthing from the drop list then an other message
    appears from the access.

    That means that your suggestion is ok for the first time that the user leave
    this field whithout to fill it.
    But the second time when the user focus the same field in the same record
    there is problem because the access displays an other message.
    --
    Kimon
    Thanking you in advance for your collaboration

    "Steve Schapel" wrote:

    > Kimon,
    >
    > Can I just check here:
    > - You have a field where the Validation Rule property in table design
    > is set to Is Not Null
    > - You enter a new record on the form, and leave this field empty
    > - There is no error message when you leave the record?
    >
    > If so, I cannot understand why this would happen.
    >
    > --
    > Steve Schapel, Microsoft Access MVP
    >
    >
    > Kimon wrote:
    > > I did it but when i add in the subform (continuos form) a record whithout to
    > > fill the rest fields (required), i focus (click) the previous record and
    > > nothing happens. The new record that i added has empty fields.

    >
     
  7. Steve Schapel

    Steve Schapel
    Expand Collapse
    Guest

    Kimon,

    Kimon wrote:
    > That means that your suggestion is ok for the first time that the user leave
    > this field whithout to fill it.


    Normally the Validation Rule would only be applied if you do anything
    that would cause the record to be saved. For example, close the form,
    or move to another record, or an event that has mnacro or code that
    forces a save of the record. It normally would not be applied when you
    leave the field (unless the Exit or LostFocus event has code to force a
    save).

    > But the second time when the user focus the same field in the same record
    > there is problem because the access displays an other message.


    So, what is the "other message"? And do I read correctly that it is
    when the focus goes *to* the combobox the second time?

    --
    Steve Schapel, Microsoft Access MVP
     

Share This Page