Solved

ActiveX List/Grid Control

Posted on 1999-01-04
5
360 Views
Last Modified: 2008-03-10
Do you know either a list or a grid ActiveX control that allow you to set the colour/font/size of each cell independantly ?
Now I know a lot of the ones for VB, but they are NOT suitable for Access, so please only controls that are known to be working in Access.
Points will be given to the first suplier of the selected control.
Cheers!
0
Comment
Question by:Carmy
  • 3
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Helicopter earned 250 total points
ID: 1972532
The MS Flex grid allows you to do all the things you want (through code at run time). It is found as MSFlxGrd.ocx  in windows\system and works with Access 8 (I don't know about other versions)
0
 
LVL 1

Author Comment

by:Carmy
ID: 1972533
Helicopter!
Thanks this is a good start, but... (there has to be one!)
MSFlxGrd is actualy part of VB5/6 so it did require some hunting for the file.  However, What the control is to do is to replace a list control and display different colours for data as it meet certain criteria.
What this control is lacking as far as I can see is the ability to change the COLOR of the data in a cell and also to change the width of columns as required.
Possible?
0
 
LVL 8

Expert Comment

by:Helicopter
ID: 1972534
To be honest I've never used it in anger, but don't the cellforecolor and the cellwidth properties do just that?

I'm at work at the moment, but I'll have a look later if you like. Have a look at the help topics for the control though, it's fairly extensive and I'm sure it will do what you want.
0
 
LVL 1

Author Comment

by:Carmy
ID: 1972535
Helicopter!  
The help on the access side is very limited, but when i looked from the vb side all was explained (sample too...), so ignore the last comments.  Last thing I need to know (and then the points are yours) is is there any way to bound this to the data, VB does it but I could not figure out how to do it in Access.
Thanks
0
 
LVL 8

Expert Comment

by:Helicopter
ID: 1972536
Hmmm, I kind of thought that one might be coming.

There is a datasource property which, as you say, can refer to a data control in VB. It looks as though this isn't available from within access.

Article ID: Q16492 in the MSDN says:

When you add a data-aware (bound) control to a UserForm, the DataSource property is not available to link the bound control to a Data control.

(Although not specific to Access I think it applies)

WORKAROUND

You must use the DataSource property to bind a data source to a control. Because the DataSource property is not an available property, you cannot bind the control to a data source. To workaround this problem, use Visual Basic for Applications commands to populate the controls that are listed in this article. For additional information, please see the following articles in the Microsoft Knowledge Base:

  ARTICLE-ID: Q164922
   TITLE     : How to Fill the Microsoft Visual Basic 5.0 FlexGrid Control

This article is more for excel or word as it refers to userforms, but the principle is the same.


There is also this telling coda to the main article:

Microsoft is researching this problem and will post new information here in the Microsoft Knowledge Base as it becomes available.


0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

In the article entitled Working with Objects – Part 1 (http://www.experts-exchange.com/Microsoft/Development/MS_Access/A_4942-Working-with-Objects-Part-1.html), you learned the basics of working with objects, properties, methods, and events. In Work…
Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
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 …

758 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

20 Experts available now in Live!

Get 1:1 Help Now