Problem with custom format (SOLVED)

[phantom1975]

This is what I have:

If Len(TextBox1.Value) = 10 Then
format(TextBox1.Value,"(###) ###-####")
End If

I get the following error:

Compile error

Expected: =

_________________
The only dumb question is the one that isn't asked. Pass on what you have learned.
This message was edited by phantom1975 on 2002-10-25 14:50

 

[Mudface]

Format is a function not a method, so you will need something like this: -
<pre>
With TextBox1
If Len(.Value) = 10 Then
.Value = Format(.Value, "(###) ###-####")
End If
</pre>

 

[phantom1975]

I hate to be a pest, but I guess I don't understand the difference. Will you enlighten me?

 

[phantom1975]

I figured it out. Basically, I can't just have it "do" what I want. I have to reassign the value. Thanks for your help.

 

[Mudface]

Sorry, you need to add an End With to the code above, too.