WITH THISFORM.Pgf1.Page2.Pgf1.Page1.GrdAttr AS GRID .Left= 0 .Top= 50 .Width=406 .Height=217 .AllowCellSelection=.f. .AllowHeaderSizing=.f. .AllowRowSizing=.f. .DeleteMark=.f. .GridLines= 0 .HighlightBackColor=RGB(0, 0, 255) .RecordMark=.f. .ScrollBars= 2 .SplitBar=.f. .RECORDSOURCE="curCONFLAGS" * .RECORDSOURCE="ccAttr" .COLUMNCOUNT=2 .COLUMNS[1].CONTROLSOURCE=[curCONFLAGS.groupname] .COLUMNS[1].header1.CAPTION=[Group] .COLUMNS[1].header1.alignment=2 .COLUMNS[1].header1.fontsize=8 .COLUMNS[1].WIDTH= 120 .COLUMNS[1].Text1.ALIGNMENT=0 .COLUMNS[2].CONTROLSOURCE=[curCONFLAGS.fname] .COLUMNS[2].header1.CAPTION=[Attribute Name] .COLUMNS[2].header1.alignment=2 .COLUMNS[2].header1.fontsize=8 .COLUMNS[2].WIDTH= 260 .COLUMNS[2].Text1.ALIGNMENT=0 ENDWITHThe funny thing is that when run, the colums are CENTERED sort of
SELECT groupname,fname,flag_id FROM curCONFLAGS INTO CURSOR ccAttrand change the cursor name to reflect the new cursor name the grid looks like expected, both columns left justified!
"SELECT "+; "Conflags.conflag_id,"+; "Conflags.contact_id,"+; "Conflags.flag_id,"+; "Conflags.insdttm,"+; "Conflags.insuser_id,"+; "Conflags.upddttm,"+; "Conflags.upduser_id,"+; "Flgroups.groupname,"+; "Flags.fname"+; " FROM kba_data!conflags INNER JOIN kba_data!flags ON Conflags.flag_id = Flags.flag_id INNER JOIN kba_data!flgroups ON Flags.flgroup_id = Flgroups.flgroup_id"peter