Results 1 to 2 of 2
  1. #1
    MHReditor is offline Novice
    Windows 10 Office 365
    Join Date
    May 2022
    Posts
    1

    Expression Builder won't accept change in value

    I am trying to change the value in this expression to accept the current year. When I click OK, no change results in the expression. I do not get an error message. I thought it might be a limitation on my account so I asked my boss to try it, but she had the same result.





    Do I need to get my account authorized somewhere in order to make this change? Or is there another problem?

  2. #2
    Gicu's Avatar
    Gicu is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    Jul 2015
    Location
    Kelowna, BC, Canada
    Posts
    4,115
    You have the field's data type defined as (short) text and yet you try to validate against numbers; change the data type to Number (long) and try again.

    Cheers,
    Vlad Cucinschi
    MS Access Developer
    http://forestbyte.com/

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

Similar Threads

  1. Replies: 11
    Last Post: 06-16-2022, 08:45 AM
  2. About Expression Builder
    By notrino in forum Forms
    Replies: 5
    Last Post: 10-17-2018, 10:43 AM
  3. Replies: 4
    Last Post: 05-03-2016, 01:51 PM
  4. Expression Builder Help
    By Vibhor in forum Access
    Replies: 4
    Last Post: 12-11-2013, 11:42 AM
  5. Replies: 2
    Last Post: 11-20-2012, 03:21 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