indenting of numbering data

[mdtam]

hai all..

i designed my data report and it shows similar like this

1. vbforums is good to solve 
your problem

what should i do to change the hanging text format like:

1. vbfourms is good to solve
    your problem

[si_the_geek]

Welcome to VBForums

Thread moved from the 'VB6 and Earlier' forum to the 'Reporting' forum

[wes4dbt]

Make the number and the text two different controls.

[mdtam]

ok i can make it two controls but it will give me numbering problem..how can i generate the numbers if they are seperated?

[wes4dbt]

What is the datasource for this report? If it's a database table then you could add the number as a field in that table. You need to explain more about how you generate this report.

[mdtam]

I'm using ms access with vb6 and ADO. User will select the data randomly by using checkboxes. If I add a field for numbers, it won't produce the numbers in sequence. How can I generate the numbers automatically sequence.

[wes4dbt]

As far as I know there is no way to auto increment a report object using the DataReport, haven't used it though for a long time. But, you can control the number field by code when you add records to the database. When you retrieve records from the database you would use "Order By" in the SQL statement. Are you using an ADO Recordset or dataEnvironment for the reports datasource. It would be helpful if you posted the code you using for generating the data for the report.

[mdtam]

Well I'm using DE as my report's data source. Here's my SQL code in DE :

SELECT * FROM table1 WHERE Classroom like 'C%' ORDER BY NAME

I can add numbers and order them. It's good if i want to show all of them but got problem if I just want to retrieve only several records. I want the numbers look like 1,2,3,4... till the end even I selected randomly records.