In Access XP I have a field "Year" in a table as a long integer.
In a form based on the table, the textbox txtYear has the above field as its Control Source.
For the properties I entered:
Validation Rule: >1980 AND <2040
For Validation Text:
"You must enter a year between 1980 and 2040"
When I run the form, and go outside the RULE, the cursor just hangs in the textbox, no message. The same was true directly from the table.
I have no problem with this in Access97. What gives?
I'd appreciate any help!
In a form based on the table, the textbox txtYear has the above field as its Control Source.
For the properties I entered:
Validation Rule: >1980 AND <2040
For Validation Text:
"You must enter a year between 1980 and 2040"
When I run the form, and go outside the RULE, the cursor just hangs in the textbox, no message. The same was true directly from the table.
I have no problem with this in Access97. What gives?
I'd appreciate any help!