Prev: Control Collection problem, who to return control "index"
Next: Save and save as
From: johnnykunst on 24 May 2010 06:20
Unfortunately most users of the form wouldn't have a clue how to do it, and as staff use different computers, even if I was to manually select the calendar control on their computers, they may be using one that isn't their usual one when inputting on the form.
Is there any other way to control how a user inputs a date in a form field? I need to enforce inputting of the date in a uniform way ie: 24-05-2010 formatted to display Monday 24-05-2010. I'm using Word 2003 at work, so am a bit more limited.

---
frmsrcurl: http://msgroups.net/microsoft.public.word.vba.general/Calendar-control-in-Word-2003
From: Graham Mayor on 24 May 2010 07:20
You might have more success with the Microsoft Date and Time Picker Control
6.0 installed with Windows\System32\MSCOMCT2.OCX which is more likely to be
installed by default and which you can add to the vba controls toolbox and
from there to your form. It is coded in much the same way but is somewhat
simpler (and less elegant) to use. If that is not possible then you are
going to have to set the formfield as a date type and set an input mask to
give you the layout you require - there is however still some scope for
erroneous entries.

--
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>
Graham Mayor - Word MVP

My web site www.gmayor.com
Word MVP web site http://word.mvps.org
<>>< ><<> ><<> <>>< ><<> <>>< <>><<>


"johnnykunst" <user(a)msgroups.net/> wrote in message
news:OaqPBry%23KHA.4308(a)TK2MSFTNGP04.phx.gbl...
> Unfortunately most users of the form wouldn't have a clue how to do it,
> and as staff use different computers, even if I was to manually select the
> calendar control on their computers, they may be using one that isn't
> their usual one when inputting on the form.
> Is there any other way to control how a user inputs a date in a form
> field? I need to enforce inputting of the date in a uniform way ie:
> 24-05-2010 formatted to display Monday 24-05-2010. I'm using Word 2003 at
> work, so am a bit more limited.
>
> ---
> frmsrcurl:
> http://msgroups.net/microsoft.public.word.vba.general/Calendar-control-in-Word-2003


First  |  Prev  | 
Pages: 1 2
Prev: Control Collection problem, who to return control "index"
Next: Save and save as