how to create an input mask

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jennifer P - 08 Jul 2005 15:54 GMT

I want one of my fields to display "July 08, 2005" but I want to input it as
07/08/05. What would the code be for this in the Input Wizard?

Thanks Jen

Reply to this Message

Dennis - 08 Jul 2005 16:06 GMT

Does it have to be July 08, 2005 or can it be 08 July 2005 ?
If Yes then simply put Long date as the format property of your box. When
you type in 8/7/05 and move away from the field it will change to 08 July 2005

> I want one of my fields to display "July 08, 2005" but I want to input it as
> 07/08/05. What would the code be for this in the Input Wizard?
>
> Thanks Jen

Reply to this Message

Jennifer P - 08 Jul 2005 22:32 GMT

Is there a reason it can not be done the other way?

> Does it have to be July 08, 2005 or can it be 08 July 2005 ?
> If Yes then simply put Long date as the format property of your box. When
[quoted text clipped - 4 lines]
> >
> > Thanks Jen

Reply to this Message

John Spencer (MVP) - 09 Jul 2005 01:31 GMT

Your FORMAT for the control should be mmmm dd,yyyy.

Your input mask should be mm/dd/yy

Note that the format property controls the display of the data into the control
unless the control has the focus. When the control has the focus the display is
set by the input mask.

> I want one of my fields to display "July 08, 2005" but I want to input it as
> 07/08/05. What would the code be for this in the Input Wizard?
>
> Thanks Jen

Reply to this Message