XP Validation Rule/Text Ptroblem

Sorrells

Registered User.
Local time
Today, 04:59
Joined
Jan 13, 2001
Messages
258
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! :confused:
 
You know, it may take a while to like XP!

In this case, after entering the post, I closed the dB, opened it again and the Validation Rule/Text worked!

I have the Access XP on an old Dell GXi 200 mhz. 126MB of RAM. Perhaps this is part of my problem.

Anyway, no need to respond. If anyone else has this problem, close the program and reopen it. It works for me, at least for now....
 

Users who are viewing this thread

Back
Top Bottom