DataGrid wordwrap

[RTDesi]

Hey, I"m using a datagrid trying to display a table from an access database. Basically, I want to show all the records in the table. Some of the fields are quite lengthy (ie memo datatype). I tried using the 'wrap text' option found in the properties under the layout tab. For some reason, the whole record is still not displayed. Any info on this will be greatly appreciated. Thanks in advance

 

[DougP]

Did you make the cell big enough to see it?? DougP, MCP

Visit my WEB site

http://www.barcodeone.com

to see how Bar-codes can help you be more productive

 

[RTDesi]

Basically, I made the cell a specified width and I wanted the text to wrap if it exceeded the width of the cell. So, 'making the cell big enough' wouldnt be a problem. That's what I"m trying to avoid. I dont want to have to size the cell the fit the text, but rather, have the amount of text dictate the size of the cell.

 

[HermanvLimbeek]

Using the FlexGrid I calculate the rowheight depending on the length of the text I want to display. First I set the minimum rowheight.

dim iLength as Integer
dim iCellWidth as integer
iCellWidth = 15 'specify the number of characters that can be displayed in a cell with standard height
With FG1
.RowHeightMin = TextHeight("X&quot
.WordWrap = True
iLength = Len(Trim(TextToDisplay))
if iLength > 15 then
'set the height of the last added row
.RowHeight(.Rows -1) = TextHeight("X&quot * iLength \15
end if
End With

It works in a flexgrid, so it might also work in a datagrid, but I haven't tested it.

Herman :-Q