You really need to define a cursor with the same structure as your SQL select cursor for when the grid initializes it's control source. Whatever the current work area is at the time the grid instanciates will control the grid appearance. There are several other things you may have to do since you're essentially pulling the rug out from under the grid by re-creating it's recordsource.
Before you recreate the cursor for the grid, you need to save all the column widths in an array, then set the grid.RecordSource property to "", recreate your cursor, then reset the column widths and then reset the RecordSource to your cursor alias. Fred On Mon, Oct 19, 2015 at 8:04 AM, Desmond Lloyd <[email protected]> wrote: > Good Morning all, > > A little out of practice.... > > Defined a grid, adjusted my column widths, added my headers. Looks great > in the editor. > > When I first fire up the form the recordsource is left empty pending the > results of a query based upon input from the user. For some reason the > grid blows off my column width! The first three columns are great, the > next few are one chacter wide, then normal. Total of 13 columns. > > After adding the recordsource and manually setting the width on one of the > one character columns it adjusts itself. When the user is going to make > another inquiry I blank out the record. Same thing, i define the width > and all is good, the rest are nasty. > > Should I define my column widths during the init of the form so it will > maintain its neat appearance? > > Suggestions... > > TIA, > Desmond > > > --- StripMime Report -- processed MIME parts --- > multipart/alternative > text/plain (text body -- kept) > text/html > --- > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/cajcbksoxfurwssww4iut2iplxq1ant6yzzq6mntxkddzhuf...@mail.gmail.com ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
