Solved

Column Color

Posted on 1998-08-03
5
370 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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

A simple tool to export all objects of two Access files as text and compare it with Meld, a free diff tool.
Did you know that more than 4 billion data records have been recorded as lost or stolen since 2013? It was a staggering number brought to our attention during last week’s ManageEngine webinar, where attendees received a comprehensive look at the ma…
Learn how to number pages in an Access report over each group. Activate two pass printing by referencing the pages property: Add code to the Page Footers OnFormat event to capture the pages as there occur for each group. Use the pages property to …
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.

740 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