Want to check if a field is a number in VB

[Larshg]

Hi

I would like to check if a field is a number in Visual Basic code.

Thanks

 

[MarkMcD]

Try the isNumeric function.

Cheers,
Mark.

 

[Larshg]

Does anyone know if there is a isNotNumeric funktion - I can't get it to work for me. This is the code for it

If IsNotNumeric(Me.EstimatedRunTime) Then
strMsg = "The fiels Estimated Run Time has to be a number - it is the Run time in minnutes"
MsgBox strMsg
Else


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70

 

[cmurray78]

there is no isNotNumeric function but u can do it this way

If Not IsNumeric(Me.EstimatedRunTime) Then
strMsg = "The fiels Estimated Run Time has to be a number - it is the Run time in minnutes"
MsgBox strMsg
Else


DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70