Solved

ActiveX List/Grid Control

Posted on 1999-01-04
5
385 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

Three Reasons Why Backup is Strategic

Backup is strategic to your business because your data is strategic to your business. Without backup, your business will fail. This white paper explains why it is vital for you to design and immediately execute a backup strategy to protect 100 percent of your data.

Question has a verified solution.

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

Suggested Solutions

Regardless of which version on MS Access you are using, one of the harder data-entry forms to create is one where most data from previous entries needs to be appended to new records, especially when there are numerous fields and records involved.  W…
As tax season makes its return, so does the increase in cyber crime and tax refund phishing that comes with it
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Using Microsoft Access, learn some simple rules for how to construct tables in a relational database. Split up all multi-value fields into single values: Split up fields that belong to other things into separate tables: Make sure that all record…

773 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