Design In Access 2007 Then Compile In A2003 Question

[Wayne]

I'm trying to overcome the problem that some users including myself
have noticed with combo boxes in A2003 databases that are run in
A2007. When the combo is tabbed out of the backstyle changes to
transparent. I haven't yet seen a fix for this.

If I design in A2003 now and then run the DB in A2007 in future the
combo box problem may arise. What I have thought of doing is
designing in A2007 and then compiling in A2003 for my current A2003
users. When they upgrade to A2007, I will compile the DB in A2007.
Are there any gotchas with this approach?

[Allen Browne]

You whould e fine with that approach.

For the combo-goes-transparent problem, try setting the new Alternate Back
Color of the (Detail?) section to something other than "No Color." This
should provent the problem in A2007, and have no effect on A2003. AFAIK,
there's no fix but this should work around it.

I would also suggest you decompile in A2003 before compiling. Just to be
sure.

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"Wayne" <cq*******@volcanomail.comwrote in message
news:46**********************************@z18g2000 prn.googlegroups.com...

I'm trying to overcome the problem that some users including myself
have noticed with combo boxes in A2003 databases that are run in
A2007. When the combo is tabbed out of the backstyle changes to
transparent. I haven't yet seen a fix for this.

If I design in A2003 now and then run the DB in A2007 in future the
combo box problem may arise. What I have thought of doing is
designing in A2007 and then compiling in A2003 for my current A2003
users. When they upgrade to A2007, I will compile the DB in A2007.
Are there any gotchas with this approach?

[Wayne]

On Oct 31, 4:13*pm, "Allen Browne" <[e-mail]:

You whould e fine with that approach.

For the combo-goes-transparent problem, try setting the new Alternate Back
Color of the (Detail?) section to something other than "No Color." This
should provent the problem in A2007, and have no effect on A2003. AFAIK,
there's no fix but this should work around it.

I would also suggest you decompile in A2003 before compiling. Just to be
sure.

--
Allen Browne - Microsoft MVP. *Perth, Western Australia
Tips for Access users -http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

Thanks very much Allen. Changing the alternate back colour fixed the
combo box problem. I don't understand why but as you say, it does. I
had tried everything I could think of to overcome this, but hadn't
tried changing the alternate back colour. With this fix, there is
probably no need for my other approach of developing in A2007 and then
compiling in A2003.