Bizarre form behavious

[iankerry]

Hi

I am working on a database for a local charity.

On my computer everything works well and I cannot replicate the problem they are having with the database. It isnt a serious problem just very inconvenient and i cant think why it might be happening.


It concerns onwe control on one of the forms. A Combo box.

when on their computer, someone clicks on the Combo, and then clicks off it, the background of the combo becomes the same colour as the background, making the text in that Combo unreadable.

So why might their version of the database do this and not mine. Does one have to assume that it is nothing to do with Access as essentially the program is the same program, and therefore that it must be a computer issue?

i have checked that we both have the same version of access (2007 - 12.0.6211.1000 sp1 mso.

does anyone have any ideas?

thanks

ian

 

[gemma-the-husky]

is the combo box in the form header?

if you have no data in the form itself, (and possibly the form is set to not allow additions) then things like this in the header can start to behave strangely like this.

is this a possibility

 

[iankerry]

Re: Bizarre form behaviour

Hi GTH

Thanks for reply.

no it isn't in the header but in the detail section. Though interestingly there are tab controls on the page and the combo in question (along with 3 others which dont have this problem interestingly), is not on the tab - so it is viewable whichever tab you are on. Is that clear?

thanks.

Ian

 

[missinglinq]

From Allen Browne's article on 2007 bugs, which I think addresses your
problem:

"A combo may display as transparent when focus leaves it. Workaround: set
the AlternateBackColor property of the the (Detail) Section to something
other than "No Color", e.g. #80000027."

 

[iankerry]

thanks very much, i'll give it a go... and report back.

ian

 

[iankerry]

Re: Bizarre form behaviour

Well it worked! Thanks very much. It was bizarre though that my copy of the database had "no color" and worked ok. andtheir didn't!

anyhow, really appreciate your answer.

Ian

 

[missinglinq]

Glad you got it working!