dcsimg
Results 1 to 4 of 4

Thread: [RESOLVED] Combobox background appears transparent or same as Form backcolor

  1. #1

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    Anchorage, Alaska
    Posts
    545

    Resolved [RESOLVED] Combobox background appears transparent or same as Form backcolor

    I wasn't sure the best way to title this.

    This is a post to provide information for anyone experiencing this issue.

    Symptoms:
    When viewing a form some of the comboboxes will be black or seem to be transparent to the backcolor of the form. This can cause the text in the combobox to not be readable.

    Versions Affected:
    2007

    Using:
    Microsoft Access 2003 to Create the database application
    Using a single form type of form

    Issue:
    The issue arrises when you develop a single form with comboboxes in Microsoft Access 2003 with the intent to have it used on a computer with Microsoft Access 2007.

    What is causing it?
    The Alternate Row color is a new feature in Office 2007. However, if you have a database that was built in 2003, it is set to ?? Blank I belive.

    What was the purpose for Alternate Row Color?
    To design forms with a "green bar" like effect.

    Previous solutions provided by others in searches:
    1. Condtional formatting
    2. Using Microsoft Access 2007 to set the Alternate Back Color to White.

    My solution (Which so far, seems to be valid):
    Simple, get the controls OUT of the Detail section. Put them in the Form Header section instead.

    Assumptions for my solution:
    • You are NOT using a BOUND form.
    • You are using (default view) of "Single Form"
    • You don't use the Form Header section for much of anything
    • You have the above mentioned issue
    • You use 2003 to create/edit/update your database application
    • At least 1 of the users of your database has Microsoft Access 2007 installed.

    Details:
    The only part of a form that the Alternate Back Color is designed to be used in, is the Detail section. If you right click the form and add Form Headers and Footers, you can move all your controls from the Detail Section, to the Form Header.

    This should solve the issue. I say should, because I've tested it, but not had a chance to test it in full detail. I at least wanted to put this on the forums incase others were looking for any solution.

    This solution won't work for everyone, but for me, I never use the form Header anyways. So this works 100 times better than installing office 2007 so I can change the alternate back color for every single combobox.

    How to fix?
    1. Right Click a blank area on the Form
    2. Choose (Form Header/Footer)
    3. Increase the size of the Header to match the height of the Detail Section
    4. Move the controls up to the Header
    5. Shrink the Height of the Detail Section to 0
    6. Continue life.


    What is the Alternate Row Color?

    What are other solutions?


    (Side note, I think its kinda lame I can't add combobox or Alternate Back Color to the Tags section, but I can add "Blah" ???)
    Last edited by rack; Mar 11th, 2010 at 03:32 AM.
    Please RATE posts, click the RATE button to the left under the Users Name.

    Once your thread has been answered, Please use the Thread Tools and select RESOLVED so everyone knows your question has been answered.


    "As I look past the light, I see the world I wished tonight, never the less, sleep has come, and death shall soon follow..." 1998 Jeremy J Swartwood

  2. #2
    Super Moderator Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,335

    Re: Combobox background appears transparent or same as Form backcolor

    Quote Originally Posted by rack View Post
    (Side note, I think its kinda lame I can't add combobox or Alternate Back Color to the Tags section, but I can add "Blah" ???)
    What happened when you tried? I had no issues at all.
    Please use [Code]your code goes in here[/Code] tags when posting code.
    When you have received an answer to your question, please mark it as resolved using the Thread Tools menu.
    Before posting your question, did you look here?
    Got a question on Linux? Visit our Linux sister site.
    I dont answer coding questions via PM or EMail. Please post a thread in the appropriate forum section.

    Creating A Wizard In VB.NET
    Paging A Recordset
    What is wrong with using On Error Resume Next
    Good Article: Language Enhancements In Visual Basic 2010
    Upgrading VB6 Code To VB.NET
    Microsoft MVP 2005/2006/2007/2008/2009/2010/2011/2012/Defrocked

  3. #3

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    Anchorage, Alaska
    Posts
    545

    Re: Combobox background appears transparent or same as Form backcolor

    Said I didn't have permission to add new tags.
    Please RATE posts, click the RATE button to the left under the Users Name.

    Once your thread has been answered, Please use the Thread Tools and select RESOLVED so everyone knows your question has been answered.


    "As I look past the light, I see the world I wished tonight, never the less, sleep has come, and death shall soon follow..." 1998 Jeremy J Swartwood

  4. #4

    Thread Starter
    Fanatic Member
    Join Date
    Jul 2006
    Location
    Anchorage, Alaska
    Posts
    545

    Re: Combobox background appears transparent or same as Form backcolor

    I have confirmed with one of my end users who always complained about this problem. The fix I did worked.
    Please RATE posts, click the RATE button to the left under the Users Name.

    Once your thread has been answered, Please use the Thread Tools and select RESOLVED so everyone knows your question has been answered.


    "As I look past the light, I see the world I wished tonight, never the less, sleep has come, and death shall soon follow..." 1998 Jeremy J Swartwood

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Featured


Click Here to Expand Forum to Full Width