Formatting Textbox

I have a listbox and a few text boxes. When I click on the listbox it fills
in the appropriate fields in the text boxes. I am trying to format the
textbox. One of the fields is a phone number and the other is a date.

I have tried this

format(txtPhone.text, '999-999-9999')
txtDateofBirth.txt

Nothing works. Please advise if this is possible using VBA

Something like:

txtPhone.Text = Format(txtPhone.Text, "000-000-0000")
txtDateofBirth.Text = Format(txtDateofBirth.Text,"m/d/yyyy")

--

Vasant



"MarkVan" <dthmtlgod@yahoo.com> wrote in message
news:%23tyHTKeSFHA.1404@TK2MSFTNGP09.phx.gbl...
> I have a listbox and a few text boxes. When I click on the listbox it
fills
> in the appropriate fields in the text boxes. I am trying to format the
> textbox. One of the fields is a phone number and the other is a date.
>
> I have tried this
>
> format(txtPhone.text, '999-999-9999')
> txtDateofBirth.txt
>
> Nothing works. Please advise if this is possible using VBA
>
>
>