In VB what is the code to change a date from 10/10/04 to Oct...

[Lori Edwards]

I have a vb form with a txtbox field which asks for a Date Received = txtDtRcv

If user enters 10/10/04 I would like it to be formatted for October 10,
2004. How do I accomplish this?

 

[Chris]

Hi Lori,

Theres a post just below that shows some code that will help, but the basic
line is this:

Selection.Text = Format(Selection.Text, "DD MMMM YYYY")

But you might have to add a line in that selects the text first. Have a
look at the post from 16/10/2004 where I asked a very similar question.

Cheers

Chris