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" wrote in message
...
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