• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 325
  • Last Modified:

Only Allow Today's Date

I have a date field on my continuous form and I want to eliminate the calendar button that shows up when users click into the field.  

I also want to set up OnDblClick event that puts today's date in the field and doesn't allow the user to change the date once today is put in.  I have a function now that wont let users change the date once they leave the record.  But I want it to only allow today's date.
0
Scotto123
Asked:
Scotto123
  • 3
1 Solution
 
peter57rCommented:
Why not set the default value as today's date and lock the control completely.  (Why bother displaying it even?)
0
 
Scotto123Author Commented:
I need the user to be able to change the field from Null to today.  That's the purpose of the form.
0
 
Scotto123Author Commented:
Got it worked out.  Locked - the field and set up the following:
Me.Control.Locked = False
Me.Control.Value = Date
Me.Control.Locked = True
0
 
Scotto123Author Commented:
Figured out solution on my own.
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now