Results 1 to 6 of 6
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,097

    Maintaining transparency with sub-form text-box


    I've created an example depicting my question. If one has a form with continuous record sub-forms where the text-box controls stipulate a transparent background, how does one maintain the transparency of the background when the main form opens? As one can see in the pic, the first text-box has a white background.

    Click image for larger version. 

Name:	000.jpg 
Views:	17 
Size:	116.9 KB 
ID:	34553

  2. #2
    ranman256's Avatar
    ranman256 is offline VIP
    Windows Vista Access 2010 32bit
    Join Date
    Apr 2014
    Location
    Kentucky
    Posts
    9,550
    You can't on a form.
    all boxes must be the same.
    unless the top boxes Are the header labels, and transparents are the fields.

    you can in a report.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,097
    There's only one (1) text-box control in the sub-form. The problem is that when the RecordSource loads the text-box corresponding to the 1st record has it's backstyle changed from transparancy to white, as pictured in my original post.

    Click image for larger version. 

Name:	001.jpg 
Views:	15 
Size:	55.4 KB 
ID:	34555

  4. #4
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    Add a textbox. Set back style transparent; border transparent, width/height 0. On open, set focus to it. If you're allowing tab stops on the other controls, you may want to set this one's tab stop to no so that the cursor doesn't disappear if user attempts to tab to it.
    Last edited by Micron; 06-27-2018 at 04:07 PM. Reason: clarification
    The more we hear silence, the more we begin to think about our value in this universe.
    Paraphrase of Professor Brian Cox.

  5. #5
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    2,097
    OUTSTANDING! I did think about where I could SetFocus but it never occurred to me to create an essentially invisible 0x0 "target".
    Thanks,
    Bill

  6. #6
    Micron is offline Very Inert Person
    Windows 10 Access 2016
    Join Date
    Jun 2014
    Location
    Ontario, Canada
    Posts
    13,423
    NP. Glad it helped.

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

Similar Threads

  1. Replies: 17
    Last Post: 11-19-2015, 03:05 PM
  2. Replies: 7
    Last Post: 05-21-2015, 09:23 AM
  3. Import from a Text File while maintaining database relation
    By robbeh in forum Import/Export Data
    Replies: 3
    Last Post: 03-12-2015, 03:07 PM
  4. Replies: 2
    Last Post: 05-10-2013, 03:19 AM
  5. Command Button Border Transparency Issue!
    By JeffG3209 in forum Database Design
    Replies: 4
    Last Post: 06-29-2011, 07:50 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