Can the iGrid control be used in Access reports?

iGrid can be inserted into sections of a Microsoft Access report like any other ActiveX control, but it cannot be printed on paper 'as is'.

How would you like to use iGrid in AAccess reports?

Hi Igor,

I use your grid mostly on forms (love it) but I am having a formatting problem on a report and was thinking that maybe the grid could help. I will explain.

I have a table in SQL Server with a text field (varchar). The table is populated from an accounting program that has nothing to do with Access. Sometimes the text in this field has line breaks. When I display this text in an Access textbox (on both reports and forms) the line breaks are removed.

HOWEVER, if I display this text field in iGrid on a form, the line breaks are honored! Your grid knows there are line breaks and shows them but Access text boxes remove the line breaks. So I was thinking of using the grid in a report.

I think the problem is that Access requires the Chr(13) + Chr(10) character combination (carriage return + line feed) to identify a line break. But your grid is smarter and knows there is a line break stored in the text field. What character does your grid look for to identify a line break?

I solved the problem! SQL Server is storing a line break (when written by the accounting program) as only ascii 10 and Access needs ascii 13 and 10. A simple Replace() function fixed my report.