Expression Error

  • 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!
 
Try to open the form directly in Design View. No code will run as long as
you don't try to view it in Form View. If the form opens automatically when
the database opens, try holding your finger down on the Shift Key as you
open the database.
--
Arvin Meyer, MCP, MVP
Microsoft Access
Free Access downloads
http://www.datastrat.com
http://www.mvps.org/access
 
Thank you Arvin - 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. 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 too much trouble?
 
i usually put the following function in a standard module, as

Public Function isUpperCase()

If Not IsNull(Screen.ActiveControl) Then
Screen.ActiveControl = StrConv(Screen.ActiveControl, vbUpperCase)
End If

End Function

and call it directly from the control's AfterUpdate line in the Properties
box, as

=isUpperCase()

hth
 
Back
Top