I have a date box within my form which is set as a date box within the table which is all good, I want users when they click in the box to only be able to add today's date or one in the future.
Any help would be great.
I have a date box within my form which is set as a date box within the table which is all good, I want users when they click in the box to only be able to add today's date or one in the future.
Any help would be great.
Use the ValidationRule property. Try expression: >=Date()
Then the ValidationText property could be: Date must be today or later.
Can also set the DefaultValue property to: Date()
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
Thanks, silly question where is the property box?
No such thing as a silly question!
Right click on your date box go to 'Properties'
Validation rule and text properties are under 'Data' tab