MS Access 2013 Date Picker (1 Viewer)

J

JonathanB64

New member

Local time

Today, 18:32

Joined

Mar 18, 2016

Messages

3

• Mar 18, 2016

• #1

I need to disable data entry in a text field and only let the user pick a date using the date picker. This will ensure better quality control of the user selecting the correct date instead of trying to type it out.

 

G

George J

Registered User.

Local time

Today, 23:32

Joined

Dec 4, 2011

Messages

51

• Mar 18, 2016

• #2

On the enter event of the textbox, put this (untested)
DoCmd.RunCommand acCmdShowDatePicker

 

J

JonathanB64

New member

Local time

Today, 18:32

Joined

Mar 18, 2016

Messages

3

• Mar 18, 2016

• #3

Thanks that does work. I'll see if my client will accept that.

 

S

sougata666

Registered User.

Local time

Today, 15:32

Joined

May 1, 2016

Messages

36

• May 22, 2016

• #4

Is there a better date picker available? The one in Access takes ages to select an employee's Date of Birth (obviously not born this year)!