Results 1 to 3 of 3
  1. #1
    s@s is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2020
    Posts
    14

    how to display table and field captions on error messages?

    so, I got a form labeled Πελάτες which is Greek for Customers and a textbox in there labeled AMKA which is Greek for social security number. as you can imagine my form is linked to a table named tblCustomers and AMKA is bound to a field named social_security_number with a caption of AMKA and made required.



    now, every time the user has a missing value on AMKA they get an error like 'you must enter a value in the tblCustoamers.social_security_number field'

    my understanding is that tables don’t get captions so the error msg cant display Πελάτες instead of customers.
    how about the caption of the field though being displayed in the error msg? something like 'you must enter a value in the Customers.AMKA field'

    im asking this because the end user only sees the form with all fields translated and they know nothing about social security number or whatever the field name might be in the database

    is it possible to make errors display field (and possibly table) captions?

    or is there another way to achieve this?

    thx!

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    4,859
    Table fields do have captions? I used them all the time to make forms easier to create.?
    Try adding a caption to the field and then cause the error.

    However most people put code in the BeforeUpdate event of a form to validate anything that needs to be entered, has been.?
    Then you can use the caption of the control definitely.

  3. #3
    s@s is offline Novice
    Windows 10 Access 2016
    Join Date
    Nov 2020
    Posts
    14
    Quote Originally Posted by Welshgasman View Post
    However most people put code in the BeforeUpdate event of a form to validate anything that needs to be entered, has been.?
    Then you can use the caption of the control definitely.
    Yes you are right - this is what i figured the next moment i created this post, it just works fine, thx anyway

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

Similar Threads

  1. Replies: 13
    Last Post: 03-04-2019, 10:31 AM
  2. Replies: 1
    Last Post: 09-09-2017, 01:56 AM
  3. Replies: 4
    Last Post: 03-08-2017, 01:05 AM
  4. Display multiple scrolling messages
    By GaryElwood in forum Access
    Replies: 10
    Last Post: 06-24-2013, 01:06 PM
  5. Custom messages to Access' default error messages.
    By evander in forum Programming
    Replies: 1
    Last Post: 06-26-2010, 02:06 AM

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