AlternateColors class of Stephen Lebans : Background color in Cyan

[Fabrice Vado]

Hi all,

I've tried and use finally the excellent class of Stephen Lebans for
alternate colors in the detail section of a form
(http://www.lebans.com/alternatecolordetailsection.htm).

It's work very well on my Access 2003 database : easy to install and easy to
configure (the example have all in it).

But I don't know why, since I have changed my XP version, the background off
the form is in Cyan.

I have not changed the background color of the AlternateColors class to Cyan
and I don't use Themed controls in AccessXP and higher. This option is
uncheck in my database and have no impact on the background color.

Does someone have this error ?

Thanks to Stephen to respond me directly but know I have an access web to
the news I share my problems with everyone.

 

[Stephen Lebans]

Perhaps this is a type of corruption. Create a new MDB and IMport
everything from your original MDB. See if that fixes your issue.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Fabrice Vado]

Once that append in my app. I've downloaded a new version of your example
database but the same thing happens.

I've created a new database and import all objects of your example (to be
sure of the VBA code) and the background color is always Cyan when I show the
screen.

But in my app, the background is in Cyan in design mode to :-?

I've tested to put the background color in another color but nothing happens.
I've tried also to desactivate the class in my form but it still active.

Sorry for this strange bug.

______
Fabrice

 

[Stephen Lebans]

Can you send me your MDB Fabrice?

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Fabrice Vado]

Hi Stephen,

Can you send me your MDB Fabrice?

I have send you the DB yesterday. Hope you receive it and can correct this
bug.

I think the entire problem is in the function “UpdateColorProps†because
when I comment it, my form has no background colour.

I use MS Access 2003 (v. 11.5614.5703) and Windows XP Pro 2002 with SP 1

Thanks for your help.

______
Fabrice

 

[Stephen Lebans]

Fabrice you had a Bitmap loaded as the Picture for the Form therefore
any modification to the Form section's Background Color prop would not
be visible.
Simply delete the Form's Background Bitmap and everything will work
normally.

A word of advice Fabrice. Next time you blame someone else perhaps you
should take a look in the mirror first.

--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.

 

[Fabrice Vado]

Hi Stephen,

Thanks you a lot for the time you passed on this problem. I’m agree with
you, everyone who ask a question have to verify he don’t have do things wrong.

But I never blame someone; I have just reported an error ;-)

I think the bitmap was had by the class (I have certainly save the form when
it was in view mode working on the VBA code) and the problem still here

When I delete the bitmap (thanks one more time, I never look at this because
I know that I have not inserted some bitmap), the form is clean. But when I’m
in view mode, the background is still in Cyan.

I think it’s the generated bitmap of AlternateColors that take the wrong
background colour when init with my OS settings (I don’t know which ones).
But I really don’t understand your powerful code to test something.

Have a good day and I hope this great free (I don’t forget it ;-) class will
work on all Access and all OS.

______
Fabrice

 

[Stephen Lebans]

Fabrice please understand that my code creates a Bitmap at Runtime, not
when the form is in Design view so that the Bitmap is not saved with the
Form!!!
At some point, you would have had to manually load the Bitmap into the
Form's Picture property.

If the form background is still in Cyan then:
1) You have not deleted the Bitmap
or
2) You have set the Backcolor prop of the Detail section to Cyan

Unless the form is corrupt, and I checked the one you sent me and it
appears OK, then your answer lies in #1 or #2 above. When I delete the
background Bitmap on the sample Form you sent me the background returns
to its normal configuration.

My solution does work in all versions of Access that are currently
available including Access 2003.
--

HTH
Stephen Lebans
http://www.lebans.com
Access Code, Tips and Tricks
Please respond only to the newsgroups so everyone can benefit.