how to modify the report ???

i have made a data report in VB6 and and it is about patients records and all this...
in the database on access i cud make a report where every record is in a separated page

example

the table or query has the fields Name, Age, Address
we have inserted these records
Name Age Address
1- Mike 18 LA
2- Ryan 19 NY
3- Tre 22 LB

Now when i form a report in VB6 i want to form a report that has a layout of Landscape not the normal one and i want each of the three records to be on a separate page.....
so ryan will have a page
mike will have another page
and tre will have his own
and each page will contain the complete info about the record or person

i used data environment to make the connection to the database "Database.mdb"

so can yall help me ????

thanx
:afrog:

Oh My God
Where are the replys ????

Quote:

---

i want to form a report that has a layout of Landscape

---

Set the Orientation property to landscape (it can only be set in code). If you don't see the Orientation property you must install at least service pack 4.

Quote:

---

want each of the three records to be on a separate page

---

Set the ForcePageBreak property of the Details section to 2 - rptPageBreakAfter

thanx for ur reply but
are u talkin about VB6 or Access???

i told u i did this in access and its perfectly working
i want to do it in VB6

I dont find that ForcePageBreak in VB6 although it is there in access, and plus in access i could set the orientation from the page set up, what code are u talkin about and how to write it

thanx for ur reply but cud u help me a lil bit more??

thanx

I am talking about the DataReport in VB.

Click the mouse anywhere in the Details section. Hit F4 to bring up the properties window.

To print landscape use this code
DataReport1.Orientation = rptOrientLandscape

For orientation try this

Printer.Orientation = vbPRORLandscape

my friend, i still cant find orientation or report orientation in the data report properties
and the code is for the print, i want to show a report that way

thank you

Then upgrade

Quote:

---

If you don't see the Orientation property you must install at least service pack 4.

---

where can i get it from ??