Results 1 to 3 of 3
  1. #1
    Join Date
    Jul 2002
    Posts
    15

    Unanswered: Check if field value is number

    Is there a function to verify that a field value is a number on Microsoft Access 2000?

  2. #2
    Join Date
    Jul 2002
    Posts
    55
    IsNumeric() should do it.

    If IsNumeric(me!txtShouldBeANumber) Then
    ' do something with the number
    Else
    ' alert the user the value isn't numeric
    End If

    Mull.

  3. #3
    Join Date
    Jul 2002
    Posts
    15
    Perfect! Thank you very much!

Posting Permissions

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