If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
|
#1
|
|||
|
|||
Age Limit Validation Rule
We are trying to limit the age when imputting the data on forms.
We have the customers DOB in format (dd/mm/yyyy)and are trying to limit the age to 18. Are there any validation rules to help us achieve this...? |
#2
|
|||
|
|||
Age Limit Validation Rule
You can use a table-level validation rule for this.
Open the table in Design view, click on Properties icon on toolbar, and enter this expression in the Validation Rule box: DateDiff("yyyy",[mydate],Date())+(Format("Date","mmdd")Format([mydate],"mmdd"))=18 Close the Properties window and save the table. -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "normanlives8" wrote in message ... We are trying to limit the age when imputting the data on forms. We have the customers DOB in format (dd/mm/yyyy)and are trying to limit the age to 18. Are there any validation rules to help us achieve this...? |
#3
|
|||
|
|||
Age Limit Validation Rule
Why not just compare the date being input to DateAdd("yyyy", -18, Date())?
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no private e-mails, please) "Ken Snell (MVP)" wrote in message ... You can use a table-level validation rule for this. Open the table in Design view, click on Properties icon on toolbar, and enter this expression in the Validation Rule box: DateDiff("yyyy",[mydate],Date())+(Format("Date","mmdd")Format([mydate],"mmdd"))=18 Close the Properties window and save the table. -- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "normanlives8" wrote in message ... We are trying to limit the age when imputting the data on forms. We have the customers DOB in format (dd/mm/yyyy)and are trying to limit the age to 18. Are there any validation rules to help us achieve this...? |
#4
|
|||
|
|||
Age Limit Validation Rule
That would work as well.
-- Ken Snell MS ACCESS MVP http://www.accessmvp.com/KDSnell/ "Douglas J. Steele" wrote in message ... Why not just compare the date being input to DateAdd("yyyy", -18, Date())? |
Thread Tools | |
Display Modes | |
|
|