How can I expand the DBGrid columns?

• May 1, 1999

• #2

hug

Programmer

Mar 14, 1999

46

VE

The Dbgrid changes the number of columns depending on the number of fields from the recordset. <br>

 

Upvote 0 Downvote

• May 1, 1999

• Thread starter
• #3

chongning

Programmer

Apr 30, 1999

2

US

Hi, Hug: <br>
<br>
Thanks for your replay, I thought the same thing when I worked on VB4 with add-on Dbgrid. But, however, my program in VB5 would not do it. It only shows two columns from my access table which has about 50 fields ( I need five fields to display) Do you know how can I get round it?

 

Upvote 0 Downvote

• May 4, 1999

• #4

paulcar

Programmer

May 4, 1999

2

US

If your DBGrid is bound to a data control and the database and recordsource properties are filled in just right click on the grid and select Retrieve Fields. This will pull all of the table fields onto your grid. If you don't want all of the fields set the Visible property for thoe columns to false by unchecking the visible box on the Layout tab of the properties box.<br>
<br>
If your grid is unbound you can use code to set the number of columns and column properties.<br>

 

Upvote 0 Downvote

• May 7, 1999

• #5

hug

Programmer

Mar 14, 1999

46

VE

It happened to me too once, I fixed just changed the columns property on the dbgrid and voila!.<br>
Check also the recorsource on the data control, the dbgrid bounds to the number of fields on the recorset at design.<br>

 

Upvote 0 Downvote