Solved

Column Color

Posted on 1998-08-03
5
369 Views
Last Modified: 2008-02-01
I have a main form and a subform. My sub form is in datasheet view (only)., I want to access to the datasheet by code sush as I had Hide each column by ColumnHidden property so now I finding the way to change each column color. Please give me the solution.
0
Comment
Question by:jom080298
5 Comments
 
LVL 5

Expert Comment

by:tuvi
ID: 1957869
I don't think you can change the datasheet view column color. If you want color, use continuous form instead.
0
 
LVL 10

Expert Comment

by:MasseyM
ID: 1957870
No way to change the back color of a datasheet view.. Sorry. .You could always write an ActiveX component and use it there...

- Matt
0
 

Author Comment

by:jom080298
ID: 1957871
to MasseyM,
     I can change the back color of the datasheet by DatasheetBackColor property but it change the datasheet background color not each column.
     Thank you for your answer.
0
 
LVL 9

Expert Comment

by:perove
ID: 1957872
You can not in datasheetview have different colours for each coulumn. Use continious forms instead.

0
 
LVL 1

Accepted Solution

by:
DennisH earned 50 total points
ID: 1957873
Don't waste your time reinventing the wheel.  Use a grid control like the one that comes with Sheridan Data Widgets 3.0
0

Featured Post

Networking for the Cloud Era

Join Microsoft and Riverbed for a discussion and demonstration of enhancements to SteelConnect:
-One-click orchestration and cloud connectivity in Azure environments
-Tight integration of SD-WAN and WAN optimization capabilities
-Scalability and resiliency equal to a data center

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Access database located in "cloud" storage 12 89
Record with #Error 8 33
Access 2010 change CurrentUser 5 33
MkDir to create multiple folder and subfolder 2 39
Overview: This article:       (a) explains one principle method to cross-reference invoice items in Quickbooks®       (b) explores the reasons one might need to cross-reference invoice items       (c) provides a sample process for creating a M…
Phishing attempts can come in all forms, shapes and sizes. No matter how familiar you think you are with them, always remember to take extra precaution when opening an email with attachments or links.
In Microsoft Access, learn the trick to repeating sub-report headings at the top of each page. The problem with sub-reports and headings: Add a dummy group to the sub report using the expression =1: Set the “Repeat Section” property of the dummy…
With Microsoft Access, learn how to specify relationships between tables and set various options on the relationship. Add the tables: Create the relationship: Decide if you’re going to set referential integrity: Decide if you want cascade upda…

839 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