Results 1 to 2 of 2
  1. #1
    gregd is offline Novice
    Windows XP Access 2010 32bit
    Join Date
    Apr 2013
    Posts
    10

    is there a check for error in expression builder

    Hello,
    I would like to convert a text string to integer.
    lots of posts say to use val, but it is not listed in access 2010

    So I am trying,
    Creating a field that is numeric
    then just referring to the string field.



    this works good except where it finds actual text.
    It puts the value "#Type!" in there.

    Would there be some kind of function to check for an error or check if the value is text>

    thank you

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows XP Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    48,831
    Val() wouldn't work?

    Try IsNumeric()

    I never use the expression builder.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

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

Similar Threads

  1. Replies: 2
    Last Post: 11-20-2012, 03:21 AM
  2. Expression Builder not there
    By schnuber in forum Access
    Replies: 1
    Last Post: 02-17-2012, 01:17 AM
  3. Expression Builder or VB ... Help
    By Adynn in forum Access
    Replies: 0
    Last Post: 06-03-2011, 09:51 AM
  4. Expression builder
    By PJ_d_DJ in forum Access
    Replies: 2
    Last Post: 02-24-2011, 03:38 AM
  5. Expression builder error, circular reference
    By cowboy in forum Programming
    Replies: 3
    Last Post: 07-15-2010, 12:55 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
  •  
Tech Forums: Microsoft Office Forums