Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion GroupsFormsForms ProgrammingQueriesModules / DAO / VBAReports / PrintingMacrosDatabase DesignSecurityConversionImporting / LinkingSQL Server / ADPMultiuser / NetworkingReplicationSetup / ConfigurationDeveloper ToolkitsActiveX ControlsNew UsersGeneral 1General 2
Access DirectoryToolsTutorialsUser Groups
Related Topics
SQL ServerOther DB ProductsMS OfficeMore Topics ...

MS Access Forum / Database Design / December 2004

Tip: Looking for answers? Try searching our database.

Form/Subform Question

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
iam@notarealisp.com - 23 Dec 2004 15:47 GMT
I have a subform on my main database form that has three fields.

Depending on how many of an item entered, the multiple entries on
those three fields could number as high as 20 sets of the three.

So, I have made the box for showing the three fields high enough to
show space for about five sets of three before it has to scroll.

The first data entry line of the three shows the colors I want just
fine.

BUT, until I fill in the remaining visible sets, the background below
the dataentry line is GRAY. I want to change that so it blends more
and looks nicer.

I have tried all the color settings on both the form and the subform
to no avail. At least I think I have.

Any way to change that defaut Gray without a ton of code?
Steve Schapel - 25 Dec 2004 05:59 GMT
Iam

Do you mean the subform is a datasheet?  I have never used datasheet
froms, so I'm not sure, but I don't think you can control the colours.
If you change it to continuous view, you will be able to control the
colours by adjusting the Back Color property of the Detail section.

Signature

Steve Schapel, Microsoft Access MVP

> I have a subform on my main database form that has three fields.
>
[quoted text clipped - 15 lines]
>
> Any way to change that defaut Gray without a ton of code?
iam@notarealisp.com - 26 Dec 2004 04:52 GMT
Yes, the subform is in datasheet view mode.

And to answer the question for anyone who wants to know,
I found that the Gray I was seeing was the Windows98 default
Application Background Color. I changed that to white and it blends
everything beautifully.
Steve Schapel - 26 Dec 2004 05:31 GMT
Iam,

It is good if this solution works for you.  Just be aware that changing
the Windows colour scheme may then mean unwelcome changes elsewhere with
other programmes.  And also that if you want to run your database on
other computers, you will have to change the Windows theme there too.  I
would personally steer clear of relying on Windows settings to achieve
the effect I want within a database.

Signature

Steve Schapel, Microsoft Access MVP

> Yes, the subform is in datasheet view mode.
>
> And to answer the question for anyone who wants to know,
> I found that the Gray I was seeing was the Windows98 default
> Application Background Color. I changed that to white and it blends
> everything beautifully.
Brendan Reynolds - 26 Dec 2004 12:28 GMT
I especially would not recommend changing the default application background
colour to white. We took on a new, young programmer recently, and found that
he was very fond of white form backgrounds. We had to explain to him that
those of us no longer blessed with youth can not look at his forms for more
than a minute or two without suffering eye-strain! :-(

Signature

Brendan Reynolds (MVP)
http://brenreyn.blogspot.com

The spammers and script-kiddies have succeeded in making it impossible for
me to use a real e-mail address in public newsgroups. E-mail replies to
this post will be deleted without being read. Any e-mail claiming to be
from brenreyn at indigo dot ie that is not digitally signed by me with a
GlobalSign digital certificate is a forgery and should be deleted without
being read. Follow-up questions should in general be posted to the
newsgroup, but if you have a good reason to send me e-mail, you'll find
a useable e-mail address at the URL above.

> Iam,
>
[quoted text clipped - 11 lines]
>> Application Background Color. I changed that to white and it blends
>> everything beautifully.
Jeff Boyce - 26 Dec 2004 13:30 GMT
Brendan

I was providing support to one user who had set up his/her PC in the
Windows-selectable "purple and pink" color scheme (gender changed to protect
the guilty).  Talk about your eye-strain!

Whenever I need to convey the importance of NOT getting rambunctious with
color schemes, either in talking with a young buck programmer or an
insistent user, I just reset the colors to that "p&p", and they get the
message!

Jeff Boyce
<Access MVP>

> I especially would not recommend changing the default application background
> colour to white. We took on a new, young programmer recently, and found that
[quoted text clipped - 17 lines]
> >> Application Background Color. I changed that to white and it blends
> >> everything beautifully.
iam@notarealisp.com - 26 Dec 2004 15:10 GMT
I've already changed the "white" to something more subdued.
It was amazing how much the all white screen bugged my eyes.
and I used to do that all the time when I was first into computers.

I just wanted rid of the Gray.
And Grecian Formula doesn't work on monitors.

: )
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.