473,383 Members | 1,896 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,383 software developers and data experts.

Form colors in Access XP look goofy when converting

Hello,

I have forms in my database that use grey as the back color. When I convert
them to XP, They all look goofy. The grey becomes two tone. The grey used
in the controls are dark, the grey used in the form detail is light, almost
white. I can change the back color on the forms to match the controls, but
on controls like tabs etc, it still looks goofy (since I can't change the
backcolor on a tab control or button etc.).

Is there any easy way to deal with this without having to change the display
colors to classic windows?

Thanks!
Nov 13 '05 #1
4 1812
It sounds like you are using office 2003.

This new look is called themed controls, and it simply means that your
application(s) take on a windows xp look..
(most new software looks this way).

You can turn it off, by going:

tools->options->forms/reports tab

Just un-check the "use themed controls".

I actually like the themes on, as it makes my "old" software look new. Here
is a series of screen shots with themes turned on, and off....

http://www.members.shaw.ca/AlbertKal...heme/index.htm

And, if you look at the following screens of grids, they look more modern. I
find that the old grey screens do look a bit tired, but the whole matter is
really a taste issue. (and, there is a number of issues with themed
controls).

http://www.members.shaw.ca/AlbertKal...icles/Grid.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal
Nov 13 '05 #2
Hi Albert,

Nope, using 2002 / XP. I've dealt with it for a while now, fortunately I've
had some control over workstation standards, so I've just been able to set
all workstations to "Windows Classic", but I don't want to have to do that,
and ideally, I don't want to have to change all the back color of all the
forms in the database.

Any other ideas?
"Albert D. Kallal" <ka****@msn.com> wrote in message
news:E3SQe.43334$Hk.43207@pd7tw1no...
It sounds like you are using office 2003.

This new look is called themed controls, and it simply means that your
application(s) take on a windows xp look..
(most new software looks this way).

You can turn it off, by going:

tools->options->forms/reports tab

Just un-check the "use themed controls".

I actually like the themes on, as it makes my "old" software look new.
Here is a series of screen shots with themes turned on, and off....

http://www.members.shaw.ca/AlbertKal...heme/index.htm

And, if you look at the following screens of grids, they look more modern.
I find that the old grey screens do look a bit tired, but the whole matter
is really a taste issue. (and, there is a number of issues with themed
controls).

http://www.members.shaw.ca/AlbertKal...icles/Grid.htm

--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pl*****************@msn.com
http://www.members.shaw.ca/AlbertKallal

Nov 13 '05 #3
On Tue, 30 Aug 2005 05:52:32 GMT, "Jozef" <SP**********@telus.net> wrote:
Hi Albert,

Nope, using 2002 / XP. I've dealt with it for a while now, fortunately I've
had some control over workstation standards, so I've just been able to set
all workstations to "Windows Classic", but I don't want to have to do that,
and ideally, I don't want to have to change all the back color of all the
forms in the database.

Any other ideas?


I see - your forms use the system colors (the negative numbers). These are
not actually colors at all, but indexes into the standard system color set,
and they always follow whatever windows color scheme is in effect. That's
what they're for.

The good news is that it's not too hard to write code that can loop through
all the form objects, open each one in design mode, loop through all the
controls, and replace the BackColor value of all controls that have a specific
BackColor value, then save the form. If you don't want to go to all that
trouble, buy Speed Ferret, and let it do it for you.

If you do much Access development, you'll want Speed Ferret anyway. It can
save vast amounts of time and make otherwise impractical design changes
relatively trivial.
Nov 13 '05 #4
Excellent.

Thanks Steve, will check it out.
"Steve Jorgensen" <no****@nospam.nospam> wrote in message
news:s7********************************@4ax.com...
On Tue, 30 Aug 2005 05:52:32 GMT, "Jozef" <SP**********@telus.net> wrote:
Hi Albert,

Nope, using 2002 / XP. I've dealt with it for a while now, fortunately
I've
had some control over workstation standards, so I've just been able to set
all workstations to "Windows Classic", but I don't want to have to do
that,
and ideally, I don't want to have to change all the back color of all the
forms in the database.

Any other ideas?


I see - your forms use the system colors (the negative numbers). These
are
not actually colors at all, but indexes into the standard system color
set,
and they always follow whatever windows color scheme is in effect. That's
what they're for.

The good news is that it's not too hard to write code that can loop
through
all the form objects, open each one in design mode, loop through all the
controls, and replace the BackColor value of all controls that have a
specific
BackColor value, then save the form. If you don't want to go to all that
trouble, buy Speed Ferret, and let it do it for you.

If you do much Access development, you'll want Speed Ferret anyway. It
can
save vast amounts of time and make otherwise impractical design changes
relatively trivial.

Nov 13 '05 #5

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

16
by: TD | last post by:
This is the code under a command button - Dim ctl As Control For Each ctl In Me.Controls If ctl.BackColor <> RGB(255, 255, 255) Then ctl.BackColor = RGB(255, 255, 255) End If Next ctl
3
by: Daylor | last post by:
hi. i got a sample project written in vc6. when i compile and build the exe (debug mode ) , the exe file size is 221KB, and the program work ok. if i open this project in vc7 , build the exe,...
1
by: mdawoodk | last post by:
i am getting error "input string was not in correct format" when converting a string decimal into integer value. code is like this: string strVal = ""; int nVal = 0; strVal = "14.9"; nVal...
0
Krishna Ladwa
by: Krishna Ladwa | last post by:
In Sql Server 2000 Version, I found that no Notification message box appears when converting text column to varchar but the data gets truncated to the given size for the varchar. Whereas it appears...
2
by: bipinskulkarni | last post by:
Hi, i have a field createdby with datatype GUID. In following query ,i encountered with the error "Conversion failed when converting from a character string to uniqueidentifier" select...
2
by: clintonb | last post by:
Victor said: The double value that I'm trying to convert to GCSMoney (which is implemented as cents) was produced by multiplying a dollar amount by an interest rate to get interest. double...
4
by: kingrexx | last post by:
I am creating a Form in Access 2000 to track request by month. However, we use an alternate calendar, so I need to check the Request Date to determine the New Month and Year. Here is the process...
1
by: NLR2008 | last post by:
Hi there, Can anybody help me and provide me with a SIMPLE solution to create a search form in Access 2003. I have created a database for Finance Payments and want to enable the user to...
4
by: Kelly Warden | last post by:
I want to create a form in Access to update my table automatically with the information selected from combo boxes, lists, comments, etc. Also, I want to automate this w/ some VBA or SQL or...
0
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome former...
0
by: ryjfgjl | last post by:
In our work, we often need to import Excel data into databases (such as MySQL, SQL Server, Oracle) for data analysis and processing. Usually, we use database tools like Navicat or the Excel import...
0
by: taylorcarr | last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: ryjfgjl | last post by:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
0
by: ryjfgjl | last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
0
BarryA
by: BarryA | last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.