Input mask for credit card date

[xian2]

Hi,
I am trying to validate a credit card expiry date so it is no later than three years ahead of today's date. I am OK with the validation as far as Date()+1096 which is the maximum number of days in three years but I am not sure how you would do this as a credit card expiry date is just MM/YY. I have tried validating MM/YY but apparently you need to do DD/MM/YY in Access so what I would ideally like to do is have 28 as a default day and an input mask so just the month and year can be enetered by the user e.g. 28/MM/YY where the user just clicks on the field and can enter the month and year without having o click at the beginning of M.

Any help is much appreciated.

many thanks in advance

Edd

[ADezii]

Hi,
I am trying to validate a credit card expiry date so it is no later than three years ahead of today's date. I am OK with the validation as far as Date()+1096 which is the maximum number of days in three years but I am not sure how you would do this as a credit card expiry date is just MM/YY. I have tried validating MM/YY but apparently you need to do DD/MM/YY in Access so what I would ideally like to do is have 28 as a default day and an input mask so just the month and year can be enetered by the user e.g. 28/MM/YY where the user just clicks on the field and can enter the month and year without having o click at the beginning of M.

Any help is much appreciated.

many thanks in advance

Edd

For what you wish to accomplish, I feel it is best to:
__1 Store the [Expiry Date] As Date/Time
__2 Input Mask: 99/99/00;;_
__3 Format: mm/yy
__4 Validation Rule: <Date()+1096

[xian2]

For what you wish to accomplish, I feel it is best to:
__1 Store the [Expiry Date] As Date/Time
__2 Input Mask: 99/99/00;;_
__3 Format: mm/yy
__4 Validation Rule: <Date()+1096

thank you so much for the suggestion, I will try it out as soon as I can find my darn memory stick!

Mant thanks

Edd

[MyTech]

I wanted to enter in my "Credit card expiration date" text box, just the month and the year. I don't care about the day.
Here's how I did it.


1. Field Name: "Exp".

2. In form, select "Exp" and create an 'After Update' Following macro.

SetTempVar: OD, Day([exp])
SetTempVar: OM, Month([exp])
SetValue: CDate([TempVars]![om] & "/" & ([TempVars]![od]+2000))
RemoveAllTempVars

('OD' stands for 'Old Day' and 'OM' stands for 'Old Month')

3. Format (for "Exp"): mm/yy

No need for input mask