When you blow out the grid's record source it will go back to defaults. I'd make a method that inits the grid stuff the way you want it. Before you requery, lock the screen, set the record source to a blank string, requery your data, set the record source back to the underlying cursor/table/view, call your grid init method and unlock the screen.
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Desmond Lloyd Sent: Monday, October 19, 2015 11:05 AM To: [email protected] Subject: VFP9: Grid Question 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/bn4pr10mb09135dc11f7454126c7f67f1d2...@bn4pr10mb0913.namprd10.prod.outlook.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.
