I have a form in access 97 with many fields that all need the same code.
Basically, I have code to make zero’s blend into the background color, on Form_Current.
Then I have an If Then Statement to make sure only zero’s blend in. This same as in Form_Current, but is in AfterUpdate of the specific field.
Then I have a GotFocus for the field that changes the background while you are in the box so you can see your typing, if the number had been a zero.
And finally I have a LostFocus to change the background color back.
Before I add the code for the other 120 or so fields, is there and easier way?
I just want zeros to be invisible on the form.
(Actually, my users do, I could care less. 😉 )
Loyd