Keyword Integer

  • Thread starter Thread starter Dan
  • Start date Start date
D

Dan

What is the keyword for integers? I want to say something
like:

If Me.hold = "Unlimited" Then
Hold_Time = "Unlimited
Else If Me.hold = Integer Then
Hold_Time = ...
Else MsgBox "Not a Valid Amount of hold time
End If

Also is the "Else If" correct code or is it different?

Thanks
 
Hi,
You can use IsNumeric for this
ElseIf IsNumeric(Me.hold) Then

Notice ElseIf (all one word)
 
Dan said:
What is the keyword for integers? I want to say something
like:

If Me.hold = "Unlimited" Then
Hold_Time = "Unlimited
Else If Me.hold = Integer Then
Hold_Time = ...
Else MsgBox "Not a Valid Amount of hold time
End If

Also is the "Else If" correct code or is it different?

Thanks
Click to expand...

If Me!hold = "Unlimited" Then
Hold_Time = "Unlimited
Else If isnumeric(Me!hold) Then
Hold_Time = ...
Else
MsgBox "Not a Valid Amount of hold time
End If

The problem you may face her is if you try to sort on these values. The
numbers will sort as text values E.G.

1
10
11
2
3
31
Unlimited
 
Back
Top