validation rule

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I tried to create a validation rule in a form. I obviously did it wrong.
Now when I click on ANY FIELD AT ALL, I get an error msg that Access could
not parse the expression I entered. It will not let me get back to
properties to correct or delete it. I can't go to database view, I can't get
to properties, I can't move to another record, I can't even move to another
field!! Every move I make is met with the error msg telling me to read up on
Expression Builder - but I can't get to properties to fix it. Help!
 
if you're still stuck on that open form, five hours later, then try to click
on the X button in the Title bar of the Access window, to close the
software. or right-click on the Access program button in the task bar at the
bottom of the window, and choose Close. if you're not able to either of
these, i'd say that at this point your only option is to use the Windows
Task Manager to close Access. <cringe>

if you have to close via the Task Manager, i'd assume that the db is hosed
(it may not be, but...). open Access again, create a new blank db, turn off
the Name Autocorrect option, and import all your objects except the problem
form; there's a chance that it is corrupted, specifically. if it's a fairly
simple form, i'd abandon it, and just build it fresh in the new db. if you
don't want to go that far, then import it to the new db, and run a
compact/repair. then open the form *in design view*, and fix your validation
expression.

hth
 
jlm said:
I tried to create a validation rule in a form. I obviously did it wrong.
Now when I click on ANY FIELD AT ALL, I get an error msg that Access could
not parse the expression I entered. It will not let me get back to
properties to correct or delete it. I can't go to database view, I can't get
to properties, I can't move to another record, I can't even move to another
field!! Every move I make is met with the error msg telling me to read up on
Expression Builder - but I can't get to properties to fix it. Help!
Click to expand...


Try hitting the Excape key twice to undo all changes to the
record? Sometimes switching the form to design view give
you the option of cancelling what what was going on??
Sometimes, just closing the form will succeed???

If all else fails, you can always close all other programs
and power off.

Next time test your expression under more friendly
circumstances ;-)
 
Tina and Marshall - i had not tried getting out and had saved the form - but
i was able to get out and back in in design form and delete the bad rule.
thank you both! i'm keeping your comments for future reference. what i was
trying to do - and i don't know if it's possible - is to have a rule that
requires all caps and that autocorrects if you don't use all caps. is this
possible or more trouble than it's worth?
 
rather than a validation rule, i would just "fix" the data. see the code i
posted in your other thread.

hth
 
Back
Top