Jen,

I don't think Tom said it can't be done, it certainly can, but he questioned
whether it was worth the effort. The three text box with labels in between
is a far simpler design, will look like a lot of web pages you see every
day, and can have automated tabbing.

I think you have made a wise choice.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

"JENNA" wrote in message
om...
Thanks Tom - at least now I know it can't be done. As you suggested,
I'll probably now go for the three separate textboxes approach.

Regards Jen

(JENNA) wrote in message
. com...
Hi all,

I have a text box in a userform (eg. txtmydate) that I wish to accept
valid date entries only such as: dd/mmm/yyyy.

When the userform is initialised, is there a way to have the text box
display two spaces followed by a '/' and accept only 2 numeric
characters there for the day (eg. 15), and display three spaces
followed by a '/' and accept only 3 text characters there for the
month (eg. Feb), and then accept only 4 numeric characters for the
year (eg. 2004).

So the text box would initial look something like: ' / / '

and a valid entry would be something like 15/Feb/2004.


Thanks again group for your help.

Jen