Results 1 to 9 of 9
  1. #1
    tatihulot is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    100

    Can I Keep a Field's Background Transparent When Mouse Clicks On It?

    Hello, everyone, I’m using Access 2021.

    May I request help with my form?

    I’ve changed the background color of my form, header, and footer to the same color.

    And I’ve made the back style and border style transparent.

    If I put the cursor in one of the text boxes in either the form or the header, the background turns to white.

    Could you please tell me how to configure the text boxes so they remain transparent, and don’t change color, even when the mouse clicks on them?

    Thank you very much. T. Hulot



    rbtest.zip

  2. #2
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Make the control properties the same as your form properties?
    Would that not make the controls almost invisible though?
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  3. #3
    tatihulot is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    100
    Maybe I didn't word the question right. I just want the background color of the text boxes to be the same color as the form. So, I set them to Transparent. But when I click on one of the text boxes, they turn white inside. They are no longer transparent. I just want them to remain transparent. Is that explanation any better? I attached a rough draft of the database.

  4. #4
    Join Date
    Jan 2017
    Location
    Swansea,South Wales,UK
    Posts
    6,555
    Best I can suggest is
    Code:
    Private Sub Title_GotFocus()
    Me.Title.BackColor = Me.Detail.BackColor
    
    
    End Sub
    or set the controls up on form load?

    Still think it is a stupid idea, as when the controls are empty, they disappear?
    Attached Thumbnails Attached Thumbnails stupid.png  
    Please use # icon on toolbar when posting code snippets.
    Cross Posting: https://www.excelguru.ca/content.php?184
    Debugging Access: https://www.youtube.com/results?sear...bug+access+vba

  5. #5
    tatihulot is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    100
    Ignore my post? Why?

  6. #6
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    I think the answer to your question is "no". This may be something basic to Windows, not Access property settings.

    Best could do is make form background white.

    I agree with Welshgasman. Seems odd to have most controls not visible. I occasionally have controlled visibility of controls but usually that is because their availability is based on data entry in other controls. Really prefer to use Conditional Formatting to manage enabling controls.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  7. #7
    tatihulot is offline Competent Performer
    Windows 8 Access 2013
    Join Date
    Aug 2013
    Posts
    100
    I figured it out. Keep in mind, please, that I'm pretty much a novice to database design, so I'm probably not doing everything correctly. That's the whole point of my experimenting...to learn and improve.

  8. #8
    June7's Avatar
    June7 is offline VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    53,770
    Okay, what did you do? Educate us, always nice to learn something new.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  9. #9
    Micron is online now Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,422
    I'd say make the tb normal background (being transparent won't help) and set the backcolor to the same value as the form value, which is a theme colour. That is pretty much what was said in post 2?? So I wonder who figured it out first.

    That still won't solve the empty control being invisible, so the idea doesn't make sense unless the control has a border or some kind of visual clue. Also, a tb with 0 width and height would be needed on the main form and form open event would set focus to it. That way, the 1st record won't be current when the form opens, since that will reverse highlight the tb value.

    EDIT - or forget the aforementioned tb and set the focus to Title then set the SelLength of Title to 0 upon form opening.
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

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

Similar Threads

  1. Replies: 5
    Last Post: 08-22-2018, 04:37 PM
  2. Replies: 4
    Last Post: 04-06-2017, 10:27 AM
  3. Replies: 10
    Last Post: 10-07-2016, 10:29 AM
  4. Replies: 4
    Last Post: 12-17-2015, 02:54 AM
  5. Replies: 2
    Last Post: 07-24-2013, 12:35 PM

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