Disable date picker when mde running in A2007 or greater

[GraeagleBill]

I have an app developed in A2003 that sometimes runs in a A2007 or A2010 runtime environment. In those cases, I want to disable the builtin date picker.



I tried this:

Private Sub Form_Open(Cancel As Integer)
If SysCmd(acSysCmdAccessVer) >= 12 Then Me.tbLedDate.Properties.ShowDatePicker = "Never"
End Sub

in the OnOpen event of the form that contains the control (tbLedDate) where I'm wanting to disable the picker. A2010 did not like the "ShowDatePicker" as a valid property.

How can I disable the picker from showing?

[John_G]

Try taking the ".properties" out; use

Me.tbLedDate.ShowDatePicker = "Never"

[GraeagleBill]

Still get "Method or Data Member not found" with your suggestion. Could I be missing a Reference pertaining to A2007 or A2010?

[Missinglinq]

ShowDatePicker takes an Integer for an argument...not a String!

0/Do Not Display

1/Display

Try

Then Me.tbLedDate.ShowDatePicker = 0

Linq ;0)>

[GraeagleBill]

Using:

Me.tbLedDate.ShowDatePicker = 0

Will not compile. A2003 does not recognize "ShowDatePicker" as a valid property. Error issued: "Method or Data Member not found"

[Missinglinq]

Well, that makes sense...since the DatePicker didn't exist until AC2007! What happens if you compile it in 2007 or 2010 and then run it in 2003?

Linq ;0)>

[GraeagleBill]

Yes, that's what I've concluded as well. I changed the code to test for Access version and simply suppress the use of Allen Browne's popup calendar when runtime is A2007 or higher. I could still use Allen's popup even with A2007 and A2010, but the user objects to the residual appearance of the "datepicker" icon after the Allen's popup closes.

Your idea would probably work and I'll give it a test next week if I can find time.

Thanks,
Bill