Hi all ...
I have an Access XP application that works fine at 8 separate locations.
The 9th location however has all sorts of strange things happening.
For example, as a test, I created a new database and made one form with 2
textboxes. I added the following functions behind the form:
Function SetBack()
Me.ActiveControl.BackColor = 8454016
End Function
Function ReSetBack()
Me.ActiveControl.BackColor = -2147483643
End Function
In the two textboxes gotfocus events, I've added =Setback(). In the
lostfocus events, I've added =ResetBack()
The functions are called as expected, however 'after' the backcolor has been
successfully changed, I then get an error:
"The expression On Got Focus you entered as the event property setting
produced the following error: The expression you entered contains invalid
syntax. * The expression may not result in the name of a macro, the name of
a user-defined function, or [Event Procedure]. * There may have been an
error evaluating the function, event, or macro."
Can anyone clue me in on what's wrong? I've tried installing/uninstalling
Access. This same code works fine at ALL the other locations.
Your help is greatly appreciated.
--Terry
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.512 / Virus Database: 309 - Release Date: 8/23/2003