Results 1 to 4 of 4
  1. #1
    Xarkath is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Location
    Millcreek WA
    Posts
    92

    Field Data not visible / hidden

    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

  2. #2
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    can you give us a specific example? Your post is a little too abstract for me.
    I don't understand this
    VBA script to apply the most common codes to the fields based on entry in 3 other fields and applied to a button.

  3. #3
    Xarkath is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Apr 2013
    Location
    Millcreek WA
    Posts
    92
    I am not sure how else to explain it. The 6th field LOOKS empty but when I click on it or tab to it the 2 digit code applied to it suddenly becomes visible. It is like white text on a white background being changed to black text on a white background except that no such changes are being done.

  4. #4
    orange's Avatar
    orange is offline Moderator
    Windows XP Access 2003
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,850
    I haven't experienced that.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Access Webapp - Hidden Field
    By kelvinkind in forum Access
    Replies: 1
    Last Post: 06-30-2014, 12:15 AM
  2. Button Hidden When Field Is Null
    By rad1182 in forum Programming
    Replies: 5
    Last Post: 08-14-2012, 02:33 PM
  3. Export hidden Data from report
    By sstrauss87 in forum Access
    Replies: 13
    Last Post: 01-23-2012, 08:50 AM
  4. Replies: 0
    Last Post: 01-18-2011, 07:09 AM
  5. Replies: 2
    Last Post: 01-06-2011, 04:38 AM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums