InputBox - Validating

[darinmc]

Hi

I have an InputBox and am trying to validate it...
How do I force the user to ONLY type in numbers

I.E. like an input mask?
##/##/##

InpValue = InputBox(InpMsg, InpTitle)

Dim InpTitle, InpMsg, InpDefault, InpDt
Dim InpValue As Date

InpMsg = "PLEASE ENTER INVOICE DATE - E.g. 23/05/07"
InpTitle = "Invoice Creation"
'InpDefault = Me.txtWeDt

InpValue = InputBox(InpMsg, InpTitle)

Me.tInvDt = Format(InpValue, "dd/mm/yyyy")
'If user presses cancel then Me.tInvDt = ""

If Me.tInvDt = Null Or Me.tInvDt = "" Then
MsgBox "null - some message"
Else
MsgBox "SOME ACTION"
End If

Sorry if this seems very simple lol


Thx
Darin

 

[ZmrAbdulla]

The fastest/better way is to create your own form looks like inputbox.

________________________________________________________
Zameer Abdulla
Help to find Missing people