how to genrate report for VB form for taking printout

hi
i am facing a problem in generating report for the form in VB.my form contains memo field of my acces database and when i tried generating reports using data enviroment, it gave an error Unspecified data length, and it doesnt displays emmo data fields in report. is there any other way to generate report.
Thanks in advance

Your errors are not clear. What database are you pulling the data from? How are you setting/formatting the fields that are generating the errors?

hi
i am using Access as database and the fields i am trying to pull is memo type. and the error it generates is that the field type is of unspecified data length
i am uploading my project as attachment and the problem is in report menu item.

In the Visual Basic data environment you are specifying the field in your query and when you are running the report you are getting the error? Or when you are defining the report?

hi
i am getting the error when i am running the report. also i tried to put the p_order_no (Purchase Order Number) and tenderno (Tender Number) fields in the command1 and not in command1_Grouping, then the report is generated but it is not displaying all the records,it is displaying only 2 records?????

I am unable to load your vbp project. Place static values in place of the dynamic values that you are retrieving and see if the error disappears.
...
Looking at your MS Access DDL I see you have fields that seem to be numeric defined as MEMO.

actually we have Purchase number as P/64/a/2003/ thats why i took it as memo field...
also save all the files in a folder named purchase in D drive of ur computer, it will work
anyway thanks for ur efforts
i will think for someother method to generate report..

If the purchase order number will not exceed 255 characters you could change the datatype to text.

shals - I have a couple examples you could look at.

Print Access Report From VB

and

VB Tutorials Week 15