Hello,
I have an odd situation and I am curious to know if anyone else has had this happen and if so how you fixed it.
I have 30 fields on a form that houses codes that are 1 to 2 digits in length. Some of those codes are used way more often than others so I decided to build a VBA script to apply the most common codes to the fields based on entry in 3 other fields and applied to a button. The code works great but one of the fields (the 6th one) is behaving oddly. I have tried multiple criterias for code and it is ONLY the 6th field being the pain. The code is applied to the field but it is invisable until that field gains focus by either clicking on it or tabbing to it. I checked the fields format to others of the 30 and all of the settings are exactly the same. There is not anything set in any of the events and there is not any other code pointing at those fields. This is driving me nuts; has anyone had this this happen before?
Thanks