Recommendations for Datagrid Control useable in Access

[Gregory Stapleton]

Greetings!
Can anyone suggest a 3rd party datagrid control that has
the ability to change backcolors on a per record basis
depending upon the value(s) in the field(s) of that
record. (Set by code of course.) Thank you, in advance.

 

[Ben]

I think Data Dynamics DataGrid control can do this.
http://www.datadynamics.com/
If you have access to VB, it may be easier to build it
yourself. I have a VB6 control that extends a datagrid
that could could be modified to do what you are asking.
you can reach me at (e-mail address removed)
HTH

 

[Albert D. Kallal]

Yes, there is two approaches I can recommend.

You can use a continues form, and that gets you a nice grid.

The following screen shots show this:

http://www.attcanada.net/~kallal.msn/test/bw2.gif

The next screen has a listbox on the left side, and a continues form on the
right side (I used continues form on the right side because I wanted to show
the check box).

http://www.attcanada.net/~kallal.msn/test/gs1.gif

if you want to "colour" the grid, you can use conditional formatting (you
need a2000 or later). Here is screen with this idea:

http://www.attcanada.net/~kallal.msn/test/bwshade.gif

If you want real kick in face data grid control, then check out t-list. here
is screen shot of a grid in ms-access:

http://www.attcanada.net/~kallal.msn/test/color1.gif

 

[Albert D. Kallal]

Sorry, that link to t-list is:
http://www.bennet-tec.com/TList.htm