Can Access 97 code apply to whole form? - TechRepublic
General discussion
February 14, 2002 at 03:46 AM
loydster

Can Access 97 code apply to whole form?

by loydster . Updated 24 years, 4 months ago

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

This discussion is locked

All Comments