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

You can disable it by using the Show Date Picker property of the table field
and/or form control.

Jon


"Roger" <lesperancer (AT) natpro (DOT) com> wrote

On Aug 3, 5:04*am, "Jon Lewis" <jon.le... (AT) cutthespambtinternet (DOT) com>
wrote:
um...form control works... but I've got many forms/controls
Is there a database option to turn the 'show date picker' off ?

Not that I'm aware of

Jon

"Roger" <lesperancer (AT) natpro (DOT) com> wrote

On Aug 3, 5:04 am, "Jon Lewis" <jon.le... (AT) cutthespambtinternet (DOT) com>
wrote:
um...form control works... but I've got many forms/controls
Is there a database option to turn the 'show date picker' off ?

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 (AT) cutthespambtinternet (DOT) com> wrote

--- news://freenews.netfront.net/ - complaints: news (AT) netfront (DOT) net ---