From: Roger on
it appears that access2007 has a built-in calendar
that is displayed when a date based control gets focus

is there a way to disable this feature

my application already has a calendar feature
and my date fields are formatted as 17-Aug-10

the built in calendar, once a date is selected
displays it as 8/17/2010 until the control loses focus
and the formatting is done
From: Jon Lewis on
You can disable it by using the Show Date Picker property of the table field
and/or form control.

Jon


"Roger" <lesperancer(a)natpro.com> wrote in message
news:97dcd614-c087-45b4-b52d-d42225e7fb15(a)i31g2000yqm.googlegroups.com...
> it appears that access2007 has a built-in calendar
> that is displayed when a date based control gets focus
>
> is there a way to disable this feature
>
> my application already has a calendar feature
> and my date fields are formatted as 17-Aug-10
>
> the built in calendar, once a date is selected
> displays it as 8/17/2010 until the control loses focus
> and the formatting is done


From: Roger on
On Aug 3, 5:04 am, "Jon Lewis" <jon.le...(a)cutthespambtinternet.com>
wrote:
> You can disable it by using the Show Date Picker property of the table field
> and/or form control.
>
> Jon
>
> "Roger" <lesperan...(a)natpro.com> wrote in message
>
> news:97dcd614-c087-45b4-b52d-d42225e7fb15(a)i31g2000yqm.googlegroups.com...
>
>
>
> > it appears that access2007 has a built-in calendar
> > that is displayed when a date based control gets focus
>
> > is there a way to disable this feature
>
> > my application already has a calendar feature
> > and my date fields are formatted as 17-Aug-10
>
> > the built in calendar, once a date is selected
> > displays it as 8/17/2010 until the control loses focus
> > and the formatting is done- Hide quoted text -
>
> - Show quoted text -

um...form control works... but I've got many forms/controls
Is there a database option to turn the 'show date picker' off ?
From: Jon Lewis on
Not that I'm aware of

Jon

"Roger" <lesperancer(a)natpro.com> wrote in message
news:a1ca784f-ebbd-45b1-8c61-49e29cea61bb(a)q16g2000prf.googlegroups.com...
On Aug 3, 5:04 am, "Jon Lewis" <jon.le...(a)cutthespambtinternet.com>
wrote:
> You can disable it by using the Show Date Picker property of the table
> field
> and/or form control.
>
> Jon
>
> "Roger" <lesperan...(a)natpro.com> wrote in message
>
> news:97dcd614-c087-45b4-b52d-d42225e7fb15(a)i31g2000yqm.googlegroups.com...
>
>
>
> > it appears that access2007 has a built-in calendar
> > that is displayed when a date based control gets focus
>
> > is there a way to disable this feature
>
> > my application already has a calendar feature
> > and my date fields are formatted as 17-Aug-10
>
> > the built in calendar, once a date is selected
> > displays it as 8/17/2010 until the control loses focus
> > and the formatting is done- Hide quoted text -
>
> - Show quoted text -

um...form control works... but I've got many forms/controls
Is there a database option to turn the 'show date picker' off ?


From: Michiel Rapati-Kekkonen on
But maybe this code can do it for you.
The code is to be put in a module and run from the Immediate window.
It goes through all the forms in the database and sets the 'Show Date
Picker' of the textboxes Off.

Michiel


Sub changeDatePicker()
Dim i As Integer
Dim strFormNme As String
Dim n As Integer
Dim lngCntrlType As Long
Const busy As Boolean = True

Set myDb = CurrentDb

On Error Resume Next

For i = 0 To myDb.Containers("Forms").Documents.Count - 1
strFormNme = myDb.Containers("Forms").Documents(i).Name
DoCmd.OpenForm strFormNme, acDesign, , , , acIcon

n = 0
While busy
lngCntrlType = Screen.ActiveForm.Controls(n).ControlType
If lngCntrlType = 0 Then GoTo nextForm

If lngCntrlType = acTextBox Then
Screen.ActiveForm.Controls(n).ShowDatePicker = 0

n = n + 1
lngCntrlType = 0
Wend

nextForm:
DoCmd.Close acForm, strFormNme, acSaveYes
Next

End Sub



______________________________________________________________________________________________________________________________________




"Jon Lewis" <jon.lewis(a)cutthespambtinternet.com> wrote in message
news:ZbqdnbA7-tyLv8TRnZ2dnUVZ7rednZ2d(a)bt.com...
> Not that I'm aware of
>
> Jon
>
> "Roger" <lesperancer(a)natpro.com> wrote in message
> news:a1ca784f-ebbd-45b1-8c61-49e29cea61bb(a)q16g2000prf.googlegroups.com...
> On Aug 3, 5:04 am, "Jon Lewis" <jon.le...(a)cutthespambtinternet.com>
> wrote:
>> You can disable it by using the Show Date Picker property of the table
>> field
>> and/or form control.
>>
>> Jon
>>
>> "Roger" <lesperan...(a)natpro.com> wrote in message
>>
>> news:97dcd614-c087-45b4-b52d-d42225e7fb15(a)i31g2000yqm.googlegroups.com...
>>
>>
>>
>> > it appears that access2007 has a built-in calendar
>> > that is displayed when a date based control gets focus
>>
>> > is there a way to disable this feature
>>
>> > my application already has a calendar feature
>> > and my date fields are formatted as 17-Aug-10
>>
>> > the built in calendar, once a date is selected
>> > displays it as 8/17/2010 until the control loses focus
>> > and the formatting is done- Hide quoted text -
>>
>> - Show quoted text -
>
> um...form control works... but I've got many forms/controls
> Is there a database option to turn the 'show date picker' off ?
>

--- news://freenews.netfront.net/ - complaints: news(a)netfront.net ---