Click here to Skip to main content
12,558,909 members (32,075 online)
Rate this:
Please Sign up or sign in to vote.
See more: VB Visual-Studio VS2010 VB.NET , +
I am displaying a Form within Outlook 2010 of my SQLCE Table, but both the Table (if I "Show Table Data") and the data on the Form have Column Widths that do not show all of the data.

As in Excel, if I double-click on the line at the end of the Column Header, the Column will expand to be as big as the longest entry.

Is there a way of making this occur automatically, without manually having to double-click ?
Posted 4-Dec-12 5:07am

1 solution

Rate this: bad
Please Sign up or sign in to vote.

Solution 1

If you are using a DataGridview, there is a property AutoSizeColumnsMode. Set the value as AllCells
Gary Heath 4-Dec-12 14:06pm
Perfect, thank you
Gary Heath 4-Dec-12 14:32pm
Just a thought, is there a way, therefore, to make the Form itself, shrink (or grow if necessary, to perfectly fit the re-sized Columns ?!? I guess there must be ... I'll start looking ...
Teenustar 4-Dec-12 14:51pm
You can dock the gridview in its parent container. ( if it is the form itself) and then try with the Form Properties AutoSize and AutoSizeMode.
Gary Heath 4-Dec-12 15:47pm
Yes, I got the Docking bit & I am experimenting with AutoSize & AutoSizeMode, but I can't get it to resize as I want. If I have AutoSize set to True & AutoSizeMode set to GrowAndShrink it always opens as a tiny little window, whereas if I have it as grow only, it doesn't seem to change size ... weird !
Teenustar 4-Dec-12 15:54pm
Iam not sure. But Check out this link
Gary Heath 4-Dec-12 17:46pm
Oh yuk !!! Thanks, I will keep looking & experimenting, it doesn't make sense that this can't be done !!!

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.161026.1 | Last Updated 4 Dec 2012
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100