Formatting Textbox
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
|