Datagrid And checkBox

I'm trying to use datagrid and I need to set up a colum as checkbox. I've try with the properties windows, with the dataformat and numberformat instruction but the column stay in a simple numeric format (o or 1).
Any Idea
Who is Participating?
vettrangerConnect With a Mentor Commented:
The datagrid control probably has the longest list of known bugs of any of the 'newbies' included in VB6.

In this case the function that seems to be promised by the inclusion of the item in the Format listbox simply looks not to exist.

If you need a lot of advanced grid functionality, its best to bite the bullet and get an advanced grid control. Apex Software's True DBGrid 6, and Videosoft's grid controls seem to be the two most favored.

You can download demos of both of them at

Visual Basic grid controls are actually pared down versions of these two companies grids anyway, and they'll never 'give away' all their best features inside VB.
Use True DB Grid or Farpoint Spreadsheet
This cannot be done using a DB Grid. You can use third party control Data Widgets from Sheridan, to get the thing as easy as you want it (just by clicking certain property of the column you can make it a check box). But this shall require that you procure these controls, if you already don't have one!.

The other way out is to desing a check box control on the form and move it along with the grid cell. This is cumbersome and requires a lot of coding, and it is like re-inventing the wheel.
Train for your Pen Testing Engineer Certification

Enroll today in this bundle of courses to gain experience in the logistics of pen testing, Linux fundamentals, vulnerability assessments, detecting live systems, and more! This series, valued at $3,000, is free for Premium members, Team Accounts, and Qualified Experts.

gcoAuthor Commented:
I'm not using DBgrid but datagrid, and in the datagrid properties there's an option to set up the field as Checkbox,but it doesn't work. What I want to know is how to use this properties...
Is it possible that you are using the MSFlexGrid?  If so you are correct, there is a property called CellCheck.  If this is the case, let me know and I can post some code and suggestions for you.  I have taken a quick glance at the MS DataGrid Control and do not see that the functionality is supported directly.
gcoAuthor Commented:

I use Datagrid (SP3) and in the format list propsed there's checkbox.

OK, let me doble check it when I get into the office
Sorry did not mean to post that as an answer....
gcoAuthor Commented:
No problem's...
This question was awarded, but never cleared due to the JSP-500 errors of that time.  It was "stuck" against userID -1 versus the intended expert whom you awarded.  This corrects the problem and the expert will now receive these points; points verified.

Please click on your Member Profile and select "View Question History" to navigate through any open or locked questions you may have to update and finalize them.

This is the Community Support link, if help is needed, along with the link to All Topics since many new ones were recently added.
Moderator @ Experts Exchange
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.