Results 1 to 3 of 3
  1. #1
    ForumUser is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    4

    On error


    Hi,

    Im getting an error message: 'The value you entered isnt valid for this field'.

    I want to change this with a msg box message. I know I have to place this at event (on error). But what is the error code for this message?

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    Its either in the form text box .VALIDATIONTEXT property
    or
    same property in the table field.

    if neither, then it could be vb code in the AFTERUPDATE event of the text box.

  3. #3
    ForumUser is offline Novice
    Windows 10 Access 2013
    Join Date
    Jan 2016
    Posts
    4
    Quote Originally Posted by ranman256 View Post
    Its either in the form text box .VALIDATIONTEXT property
    or
    same property in the table field.

    if neither, then it could be vb code in the AFTERUPDATE event of the text box.
    Ty for your answer. I will try it now.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 2
    Last Post: 01-04-2016, 09:40 AM
  2. Replies: 11
    Last Post: 05-01-2014, 11:56 AM
  3. Replies: 3
    Last Post: 01-23-2014, 07:49 AM
  4. Replies: 0
    Last Post: 07-16-2012, 05:42 AM
  5. Replies: 6
    Last Post: 05-30-2012, 12:32 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums