I've created a pop-up data entry form to enter charges by year.
How do I customize the format so users are required to enter the 4-digit year in all year fields. Please be specific with your instructions.
I've created a pop-up data entry form to enter charges by year.
How do I customize the format so users are required to enter the 4-digit year in all year fields. Please be specific with your instructions.
Try using the InputMask property of textbox. http://office.microsoft.com/en-us/ac...010096452.aspx
This mask requires a digit in each position: 0000
This mask prefills 2 in first position and will require input begins with 2: \2000
Or ValidationRule property, like: >=2000
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.
Ok, Thanks.