Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2005
    Posts
    43

    Unanswered: Certain Fields on Form Required

    I want to make certain fields on a form required without requiring others and I also want the error message to be different for each field.

    for example if someone forgets to input the name I want the error message to state "Please enter your name" and Higlight the name Field. and son on.

  2. #2
    Join Date
    Mar 2003
    Location
    The Bottom of The Barrel
    Posts
    6,102
    Provided Answers: 1
    A few methods are mentioned here
    oh yeah... documentation... I have heard of that.

    *** What Do You Want In The MS Access Forum? ***

  3. #3
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    As is usual in Access / VBA there are lots of ways of removing the fur from a feline....

    One way is to place some code in each relevant controls' before update event. This code populates a a message box prompting user action.

    Another option is to place the validation in the forms on update event, rolling up all the messages that would be generated in the individuals controls before update event.

    Personally I prefer the latter: the reason a single message to the user, less confusion, less need to read the screen.

    I've also found a good solution to such user interface issues is to trip the required / error controls by setting their background colour, or some other appropriate means of guiding users to problems. You can also set those controls mouseover / tooltip to indicate what the error is.

    just my 2 1/2d
    Last edited by healdem; 11-16-05 at 17:35. Reason: correcting spelling / aka not typing when pished

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •