Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

ActiveX List/Grid Control

Posted on 1999-01-04
5
Medium Priority
?
436 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
  • 2
5 Comments
 
LVL 8

Accepted Solution

by:
Helicopter earned 1000 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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

AutoNumbers should increment automatically, without duplicates.  But sometimes something goes wrong, and the next AutoNumber value is a duplicate.  This article shows how to recover from this problem.
Access developers frequently have requirements to interact with Excel (import from or output to) in their applications.  You might be able to accomplish this with the TransferSpreadsheet and OutputTo methods, but in this series of articles I will di…
With Microsoft Access, learn how to start a database in different ways and produce different start-up actions allowing you to use a single database to perform multiple tasks. Specify a start-up form through options: Specify an Autoexec macro: Us…
Have you created a query with information for a calendar? ... and then, abra-cadabra, the calendar is done?! I am going to show you how to make that happen. Visualize your data!  ... really see it To use the code to create a calendar from a q…

618 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