Acc 2010 vs 2003 conditional color on form control borders

I have discovered a pretty annoying issue with the conditional formatting in Access 2010. On a continuous form I'm using the conditional formatiing to make a "group" look using White/grey in the conditions - this is working fine and looks ok in Acc2003 - but in 2010 the border doesn't behave as they do in 2003 - so the form detail background color (White in this example) "shines through" - anyone with a bright (not White ;) idea to get rid of the unwanted border colouring in 2010 ?

2015-04-30-19-42-11.jpg
LVL 1
Mik MakConsultantAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

PatHartmanCommented:
in A2010, controls have margin and padding properties.  Change these to 0".
0
Mik MakConsultantAuthor Commented:
They're already set to 0 - and margin and padding are "inside" the border so that doesn't help with the White lines, unfortunately:)
0
PatHartmanCommented:
Try making the values different to see if they impact what you are seeing.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

Mik MakConsultantAuthor Commented:
I have tried that - no impact :)
0
Mik MakConsultantAuthor Commented:
Hmm using an unbound Picture control I've  found sort of a solution (using a streched Picture in the wanted colour) - it did initially still show borders  - but after having set the border to various colours and then back to invisible, it suddenly worked... I think Theres a bug somewhere here :)

2015-05-01-18-23-26.jpg
0
PatHartmanCommented:
I think so too.  That's why I wanted you to fiddle with the properties to see if you could jog it into doing the right thing.
0
Mik MakConsultantAuthor Commented:
I certainly appreciated the effort - but padding and margins didn't make a difference unfortunately :)
0
Martin LissOlder than dirtCommented:
I've requested that this question be deleted for the following reason:

The question has either no comments or not enough useful information to be called an "answer".
0
Mik MakConsultantAuthor Commented:
Well, if the reason for the problematic White lines, is a bug in Access, it might be worth reading, for someone on the same situation - although not an "answer" in the classical way :) ?
0
BitsqueezerCommented:
Hi,

since A2007 there is an additional element to check: If you use layouts in your controls all controls have grid settings with an own grid line color and width which you also need to check if they fit into your design.

Cheers,

Christian
0
Mik MakConsultantAuthor Commented:
Grid lines are all transparent. Grid with makes no difference if they're set to 1 or 0 :)
0
BitsqueezerCommented:
And the last thing I would check: If you have set all margins etc. to 0 you need to move up the footer bar as closest as possible to the controls, also check if all controls are topmost to the header bar and aligned all at top and all have the same height (should be the case if you have them all in one layout grid).
0
Mik MakConsultantAuthor Commented:
Good points - but all have been set and Done :)
0
BitsqueezerCommented:
Hi,

now I got the chance to create an A2003 database to recreate this issue. You're right: If I make a continous form like yours and set the border type to transparent then A2003 renders the control's background color instead of the background color of the details area.
Control Border in A2003 = Transparent
If I open the same database in A2010 it shows the background color of the details area:
Control Border in A2010 = Transparent
So the problem has nothing to do with the new layout or grid settings or conditional formatting etc., I would say it is a correction of a bug in A2003: If you set the border color to "transparent" and also if you cannot set the border width to 0 (because "0" is the value for "Hairline") I would expect to always have at least a hairline width border around the control which cannot be switched off. So if we set the style to "Transparent" it should be transparent, which means, I can see what's "under" the control, and that's the background color, which is green here to better show the effect.
It's more clear if I use a background picture in the form:
Control Border in A2010 = Transparent with Background PictureNow you can see that it is really a transparent border like the setting says. So we can say: It works now in >=A2007, the issue is with A2003! It's not logic to set the border to the control's background color if the border is set to transparent. Unfortunately there is no setting for "no border at all".

If you only have that one gray color you can simulate the A2003 effect if you set the general border color for these controls to the same gray. If you have more than one conditional formatting color then you simply can't do anything against that, I'm afraid.

Cheers,

Christian
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Mik MakConsultantAuthor Commented:
You're quite right - and thank you for investigating so thouroughly :)

I've solved it by making all the textboxes transparent, and then having a Picture object that I change the contents of :)
0
BitsqueezerCommented:
Hi,

OK, but then you can't have additional conditional formatting on these controls which will not be displayed if the control's background color is set to transparent..

Cheers,

Christian
0
Mik MakConsultantAuthor Commented:
I know :)
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Access

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.