Solved

Change forecolor in datasheet view

Posted on 2000-02-27
3
203 Views
Last Modified: 2008-03-10
Is it possible to change the forecolor of a record in datasheet view if the record meets certain criteria?
0
Comment
Question by:Dwhite
  • 2
3 Comments
 
LVL 12

Accepted Solution

by:
Trygve earned 50 total points
ID: 2562428
This is not possible (without deep windows programming which you don't want to get involved in)

There is a trick you can use on a continous form though using the background color, so if you make the detail section look like a datasheet view, you will get more or less the same effect.

Read this article on the subject:
"Changing the Background Color of the Current Record in a Continuous Form" - http://www.netservice.no/trygve/wiz/FrameText.asp?ArticleID=15B84BFD-450C-11D3-A9BB-005004227874

0
 

Author Comment

by:Dwhite
ID: 2562465
Thanks I tried it and it works great
0
 
LVL 12

Expert Comment

by:Trygve
ID: 2563832
Glad to have been of assistance :-))
0

Featured Post

Enterprise Mobility and BYOD For Dummies

Like “For Dummies” books, you can read this in whatever order you choose and learn about mobility and BYOD; and how to put a competitive mobile infrastructure in place. Developed for SMBs and large enterprises alike, you will find helpful use cases, planning, and implementation.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the previous article, Using a Critera Form to Filter Records (http://www.experts-exchange.com/A_6069.html), the form was basically a data container storing user input, which queries and other database objects could read. The form had to remain op…
In a multiple monitor setup, if you don't want to use AutoCenter to position your popup forms, you have a problem: where will they appear?  Sometimes you may have an additional problem: where the devil did they go?  If you last had a popup form open…
Basics of query design. Shows you how to construct a simple query by adding tables, perform joins, defining output columns, perform sorting, and apply criteria.
In Microsoft Access, learn different ways of passing a string value within a string argument. Also learn what a “Type Mis-match” error is about.

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now