Input Mask query

Hey, i didn;t understand how we can accept the record from the user after
disabling the mask..what's the command??/

me.phonetextbox.inputmask=false
????????????????????????? What comes here???????????
me.phonetextbox.inputmask=true

Hi Raymond,

you would do something like this in the AfterUpdate event of the UNBOUND
textbox to create a phone number:

'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
On Error GoTo Proc_Err

Dim mPhone As String

If Len(Trim(nz(controlname_UnboundPhone,""))) = 0 Then
GoTo Proc_Exit
End If

Me.Phone.InputMask = ""

Me.Phone = controlname_UnboundPhone

' clear unbound phone control
Me.controlname_UnboundPhone = null

'save the record
me.dirty = false

Me.Phone.InputMask = "!\(999"") ""000\-0000;0;_"

Proc_Exit:
Me.Phone.SetFocus
Exit Sub

Proc_Err:
MsgBox Err.Description, , _
"ERROR " & Err.Number _
& " PhonePaste"
Resume Proc_Exit

'if you want to single-step code to find error, CTRL-Break at MsgBox
'then set this to be the next statement
Resume
'~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~

WHERE
controlname_UnboundPhone is the control NAME of your unbound phone number
Phone is the control NAME of your phone number

theoretically this should work ...

~~~~~~~~~~~
for better understanding of the basics of Access, read this:

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

Warm Regards,
Crystal

remote programming and training



*
(: have an awesome day
*




Raymond wrote:
> Hey, i didn;t understand how we can accept the record from the user after
> disabling the mask..what's the command??/
>
> me.phonetextbox.inputmask=false
> ????????????????????????? What comes here???????????
> me.phonetextbox.inputmask=true
>