Tracking Forums, Newsgroups, Maling Lists
Home Scripts Tutorials Tracker Forums
  HOME    TRACKER    Visual Basic

Group By Clause In Detail Section Of A Crystal Report

sorry I couldn´t find any crystal reports forums,
as I use Visual Basic I´ll post this message here.

I´m not an expert in Crystal Reports but actually
there´s something I can´t get.

I need that the records showed in detail section
obey the following SQL sentence:

select cars.type_id,types.description,count(cars.type_id) as quantity
from cars,types
where cars.type_id = types.type_id
group by cars.type_id,description
order by description;

The group by clause in this SQL sentence is essential,
and I´ve tried a lot of things and I don´t know how
to specify the group by clause in the detail section,
or something like "edit the SQL query" that detail
section has.

If it is not possible, is there some other way to
accomplish what I need?

Thanks for the time

View Complete Forum Thread with Replies

See Related Forum Messages: Follow the Links Below to View Complete Thread
Crystal Report Detail Section
i m using crystal report 7. i know that a detail section print records until last record.
for example
EmpID EmpName ....
------ ---------
10 Jhon
20 Smith
30 jackson
40 Andrew
50 Hilton
it wil print in detail section
i want that 2 records print at 1 line in detail.
EmpID EmpName ....
------ ---------
10 Jhon 20 Smith
30 Jackson 40 Andrew
50 Hilton

how can i do this

Crystal Report Detail Section Sort
i im using C R 7.0. i have made 2 groups in my report, in second group's detail, my record is not sorted. how can i sort my record by any field.


Crystal Report->how To Split Detail Section
by default there is one detail section, do any one know how to split this detail section into two or three, etc

detail1, detail2, etc.

thanks in advance

Crystal Report Freeze The Detail Section.
 Hello friends!!!

   I want to freeze the Detail section of the crystal report. I.e I want that only 5 records should come in detail section if there are more than 5 record then it will start from the next page.

Thanks in advance!!!!


How To Show Three Detail Section In Crystal Report 10
Dear Friends,

I try to Print Report With Crystal report 10 having three Detail Section.The Fields in the Report is getting Repeated in All Section . How to Solve this.

please help me.

Very urgent.

Crystal REport Group Clause

I need a help in crystal report,i had a problem while doing group by clause,

this is my query when i test it in my sql-server it is working fine

select people.firstname,people.initial,people.lastname,sum(TotalRHBillAmount),sum(Timesheet."TotalHDBillAmount"),sum(Timesheet."TotalVABillAmount"),sum(Timesheet."TotalOTBillAmount"),sum(Timesheet."TotalAmountbill") from timesheet join people on timesheet.peoplecode=people.peoplecode Group by people.lastname,people.firstname,people.initial

how to do it in crystal report, can u help me out pls its urgent

Data Report : Detail Section (section N°1)
Is it possible in the DataReport' détail section (section 1) to make a test in a field of a recordset and then fill this section depending of this field ?
For example :
With DR.Sections("Section1").Controls
.Item("Text1").DataField = Rst.Fields("Nom").Name
Select Case rst!TypeCli
Case "Mickey"
Set .Item("Image1").Picture = Mickey.jpg
Case "Minnie"
Set .Item("Image1").Picture = Minnie.jpg
end select
end with
Here i would like to fill Image1 depending on "TypeCli" (one field of my recordset)
With that syntaxe, it does not work, it takes the first recordset and then keep the same result for all the records. If the first one is 'Mickey', i have only Mickey'pictures, if the first one is Minnie i have only 'Minnie'pictures.

This kind of syntaxe works well in the other sections but not in this one (détail). Is there a way to succeed ?

Thank a lot for your help.

Crystal Reports - I Need Totals In My Detail Section
email me
I am trying to create a somewhat complicated report in Crystal Reports. I have several levels of grouping. Once the report is sorted and grouped the way I need it to be, I need totals of the detail information. However, I need these totals to appear side by side. I had orignally thought of using a cross-tab, but can't because if there are more records than what can fit across the page, the cross tab does not wrap and ends up printing on a blank page. (My user will not accept totals running up and down on the page, must be side to side). Therefore I moved into using multiple columns. However this is only available in the details section. Since this is the case, I can't get the totals of the detail records, I can only get the detail themselves.

Any suggestions would be GREATLY appreciated. If you don't have any ideas on how to fix it, and suggestions on where I could look would be appreciated as well.


Code In Report Detail Section
I have a report that was made in Access 2000. I have some code in the Detail section and the GroupHeader and GroupFooter section of the report.
Basically it HIDES few labels on the report and unhides other labels.And conditionally adds up values for a field in the report.
I was wondering if this was possible with VB Data Reports.(i.e. executing code in different sections of the report).
Currently I call the Access reports from the VB porgram, but it looks a little messy.

Can this be done using Crystal Reports.???


Number Of Rows To Set In Detail Section Of Crystal Reports

In Crystal Reports, in detail section, I would like to set the number of records as 10. Whether the records are less than 10, I have to maintain the space of 10 records in detail section. Kindly guide me what to do for this option.

Dynamically Populate Detail Section On Report
I need help with a report problem. I am using a combination of Access and VBA to produce an invoice generation application. The invoice is produced in a report from 2 tables (customer details and jobs) in a one-to-many relationship.

The report header contains the company logo/ details etc. The report footer contains invoice total/ purchase tax etc.

Each individual line in the details section has date/ job description/ price/ tax rate and tax total for each job completed. I have used the drawing tools to draw vertical between each of these entries, so the effect is that when the report is displayed, vertical lines run down the report page.

My problem is this, when the report draws up, the details section is only as high as the number of jobs completed so, for example, if a particular invoice only has 2 jobs on it, the page is only about 1/3 full, i.e. the report header, 2 lines of detail and footer all group together at the top of the report.

What I want is for the report header to be at the top of the page (which it is) then for the detail section to extend to nearly the bottom of the page (i.e. the lines which seperate each entry on a detail line to run right down the page), stopping at the report footer, which is always at the bottom of the page - is it possible to achieve this?

Fix Detail Section Height Of Data Report
Hi I am a fresher.M going to make a project on Sale bill using data control and Access as database.My problem is that when i enter records and view bill format report it adjust height of detail section of data report automaticaly.But i have to print bill on the Printed staitionary .So i want to fix the height of detail section upto 6-7 items records(rows).Plz help me.

How To Add A Detail Section In Data Report[resolve]
hi! how to add a detail section in a data report? thanks

Edited by - say2x on 1/19/2006 12:49:25 AM

Crysyal Report Detail Section Problem
i m using detaila and detailb in crystal report but i want if page end on detala section then detail a must diaplay on next page...................

Report Problem - Repeated Records In Detail Section
Using Access 2000...
I'm having a problem in a report: information appears repeated in detail section.

This report captures data from a crosstab query. At this point, the query has only one record:

Processos Risc Combinat IND1 IND2 IND3 IND4
P1 3,656379 4 3,5 3,83 3,25

The report just shows this information in the detail section. As it's a crosstab query, the column number can vary (the number of IND -Indicators- ), so I have been forced to put a lot of text boxes in page header and detail section of the report, and in the Report_Open event I make visible the ones that contain information and invisible those ones without any data.

The problem is that the report shows this info twice:

P1 3,65 4 3,5 3,833 3,25
P1 3,65 4 3,5 3,833 3,25

Next I show the code of the detail events (quite short), because I sense the problem is there:

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)
Dim intX As Integer
' Verify that not at end of recordset.
If Not rs.EOF Then
' If FormatCount is 1, place values from recordset into text boxes
' in detail section.
If Me.FormatCount = 1 Then
For intX = 1 To intColumnCount
' Convert Null values to 0.
Me("Col" + Format(intX)) = xtabCnulls(rs(intX - 1))
Next intX
' Hide unused text boxes in detail section.
For intX = intColumnCount + 1 To conTotalColumns
Me("Col" + Format(intX)).Visible = False
Next intX
' Move to next record in recordset.
End If
End If
End Sub

Private Sub Detail_Retreat()
' Always back up to previous record when detail section retreats.
End Sub

Any idea? Thanks in advanced.

Horizontal Line In Detail Section Of Crytal Report

i have VB and Reporting tool Crystal report
corresponding Records are printed,
like, i want horizontal lines printed 21 times

as if 2 records are printed then only 2 lines are printed and below is left out blank till end

if 8 records then 8 lines are printed and below is left blank till end

is there any option that 21 lines should be printed and in that records should be printed 2 or 5 or 10 ....

could any body sort out this pbm,


Limit Rows In A Detail Section(Data Report)
Hai Every body,

The Question is Regarding data Reports
Even If there only One Row to Print in Detailed Section
Is There any command to leave the space blank
I need a space for a Total of 10 Rows
If there is one row of data
Leave the remaining 9 rows blank
And Then Print The Group Footer or what ever it is
I know This could be done in Crystal Reports
But I need to know about Data Reports

Thank you

Make Auto Number On Detail Section (data Report)
How to make autonumber on detail section (data report) as many as record numbers.

Thank friends

Group Section On Report
I created a report using Data Report and the source is a ADODB recordset that contains records from a table in a mdb file.
I put some text boxes in the "Details" section of the report and
set the DataField property to the name of selcted field.It works fine, but, when I am trying to put a text box in a Group Section, to make a grouping, it doesn't work .
Somebody can explain me what's the reason ?

VB6 Report --> Group (Repeat Section)

Originally Posted by nico_van_wijk

I have made a datareport with VB6 and add a groupheader. Everything works fine but I will repeat the group header at the top of the next page, even if we are in the middle of a group.

In an access report you can set something like Repeat Section = true.

How can I realise this with a VB report?

Did you ever find a solution to this? I am in need of the same thing

VB6 Report --> Group (Repeat Section)
I have made a datareport with VB6 and add a groupheader. Everything works fine but I will repeat the group header at the top of the next page, even if we are in the middle of a group.

In an access report you can set something like Repeat Section = true.

How can I realise this with a VB report?

Crystal Reports - Difference Between Keeping Group And Section Together
Found this helpful note on another forum and wanted to post for future reference (credit to kenhamady).

There is a difference between keeping a section together and keeping a group together.

Keeping a section together keeps a deep Group Header from splittng accross pages.

If you want the GH and GF to stay together with all subgroups or details in between you need to "keep group together".

This is in the group options for that group under Report - Change Group Expert.

Add Group Header Section In Data Report
Hi guys,
       I'm trying to create report by using data report without data environment. I created reports before but they're like tabular reports which involve only Detail Section. Now, I try to add a group header section to show data as a group. I don't know if I did this wrong since start. So, I'd really appreciate if anyone can explain me how to do this.

Let's say that below is my table

Date Order Cost
xxx 1 10
xxx 2 15
xxx 3 10
yyy 1 12
yyy 2 10

I want to show Date in group header section, Order in detail section, and TotalCost in group footer section. What I did was I had these records stored in Recordset then set datamember and datafield as I did for tabular reports. It didn't work. It showed me a message error 'Reports sections do not match data source'. So, my main questions are
1. How can I refer group header section or even add higher level to the report to my data?
2. How can I add function to the report at the end of each section?

Below is how the report should look like

Date Order Cost
                                   1 10
                                   2 15
                                   3 10
                       Sub-Total 35
                                   1 12
                                   2 10
                       Sub-Total 22
                              Total 57

Thank you so much in advance for any suggestion.

Anyone can tell me repeating the Group Head Section in each page.


Data Report, How To Show 1 Group Section Per Page?
Is there any way possible to do a page break after each group section?

I have a hierarchical disconnected recordset in order to show a group header for grouped object, and after all the data for that object is filled, I want a page break after it.

So far, I haven't found anything about being able to do it that way.  But hopefully it is possible.  Any help would be greatly appreciated.

Data Report With Group Section Doesn't Show Updated Values.
I have a datareport with group sections (group headers and group footers). At first, I've created a data environment wherein I've defined the fields that is used for grouping. The data environment is connected to a temporary table wherein values are added dynamically. My problem is everytime i show the data report it doesn't show the updated values of the table. Can anyone help me with this?

Before I am not using a data environment but instead i am using ADODB.recordset and assign it directly to the data report. But for this case, it doesn't work since I am grouping some fields... does anybody know how to make a data report with group section without using data environment? (instead using ADODB)

any help will be greatly appreciated. URGENT!

Crystal Report Report Footer And Detail Part Keep Together
We are designing crystal report for billing.
I have a problem such that I havr to display all the Billed items (may be 100's ) and then show extar additions in that total to make final total as given below.
and requirements are
a) Totalling part lines should all come in one page and that too at the bottom of the page
b) The page which contains totalling part should have atleast one billing item
(i.e even if we use keep Together for tht part in which totalling comes, then also there should be check that atleast one item of detail part should be there or in other words client doesnot want a seprate page containing total only? )

For eg (Detail Part)
Name Rate Qty Amount
Item1 10 10 100
item2 1 1 1
itemn 1 1 1

(totalling part)
Total 200
Add cartage 10
Add abc 10
add .. 10
Final Total 300

Thanks and Regards

4 Detail Page Using 1 Crystal Report?
Ok what i am trying to do is create a crystal report that print 4 pages per detail line. I have to Print Purchase Orders and i have to print out 4 forms per PO. The layout is slightly different on each PO. So this is where i am running into problems. I cant figure out a way to print 4 simultaneous POs with the same Detail but different layouts.

Any help is appretiated!

: y0use

Open Crystal Report With A Where Clause
I have a Crystal rport that is connected to the right tables and it displays the data just fine with the following code.

Option Explicit

Dim CApp As New CRAXDRT.Application
Dim CReport As CRAXDRT.Report

Private Sub Form_Load()
Set CReport = CApp.OpenReport("P:Crysta~1ToDoList.rpt")
CRViewer1.ReportSource = CReport
CReport.Database.Tables(1).SetLogOnInfo "Titus", "Problem Tracking", "Titus", "password"
CRViewer1.Zoom 100
End Sub

What I want to be able to do, is open this report for specific employees using a where clause that keys on EmpID.

Anyone have any ideas?


Details Section - Crystal Report
Hello ppl,

I need to print some labels using Crystal Reports. Each label will have 3 fields (Section, EmpCode and Salary) from each record. I have created an Empty Report, connected to the Database and drag & drop the necessary fields on the Details Section of the report.

As you know, each line of a label sheet has 3 labels per line. So what I need is to put the information from 3 different records (per line) on the Details Section of the Crystal Report (How?) What I mean is this:

Details (Section3)
(Rec1) ---- (Rec2) ---- (Rec3)
SecName - SecName -- SecName
EMpCode - Empcode -- EmpCode
Salary ---- Salary ---- Salary

* So the next line generated by the Crystal Report will be:

(Rec4) ---- (Rec5) ---- (Rec6)
SecName - SecName -- SecName
EMpCode - Empcode -- EmpCode
Salary ---- Salary ---- Salary

...and all the labels will be filled properly.

Thanks in advance for any reply.



* See the attached image for a better illustration.

Crystal Report Section Question
i want to show my specific section on next page. is it possible. i can not enlarge this section to move on next page bcuz i dont know records count. kindly tell me the way to do this.


Undelay Crystal Report Section
i m using crystal report 9 and i have a sub report in a section. i have done underlay this section. now i want that another subreport run after completion of first sub report. but both reports shown on a each other becuase of underlay. is there any other mathod that my specifice section work after the underlayed group.

Crystal Report 8.5 How To Format Section ?
Hi, All

I want to know how can I arrange the section like this in crystal report:

Page Header a
Detail a
Page Header b
Detail b

Normally ,when I insert new Page Header and Detail , it will be arrange like this :

Page Header a
Page Header b
Detail a
Detail b

I want to split these two header also with the detail , is it possible to do ?

If anyone know about this ,pls let me know
Thank you very much


How To Add Section Into Crystal Report From VB Runtime.
Question:I have created one report from Crystal report XI. I am Viewing that report into Crystal Viewer. I have added one Text Box into Report from VB Runtime. But I want to add one Section in between two sections. Please somebody help to sort out this problem...

How To Get Sum Of Detail Field In Crystal Report For This Case?
I use Sql server and created an storedprocedure that returns recordset.
And My two Crystal report file use this storedprocedure as datasource.
One crystal report display recordsets whose 'Status' field's value is 'N'
and the other one shows those with 'O' value of 'Status'.

I filtered the records on each report using ..
Report menu --> Edit formula --> Group
In formula editor {sp_GetCompareRptData.Status} = "N"

But, I have to add Sum of Amount1 field that is one of the fields returned
from the storedprocedure.
I added sum.. but, it shows whole sum of sp_GetCompareRptData.Amount1 not the
sp_GetCompareRptData.Amount1 Where sp_GetCompareRptData.Status = "N"...

I need Sum of amounts shown in the report ( filtered..)

How can I do this??

Thank you.

Crystal Report Format Problem In Detail
crystal report format problem again

Detail :
Item Description - i use 4 field display as row
row 1 - Item name
row 2 - size
row 3 - model code
row 4 - accessary

I want the report auto adjust when the value of row 3 and row 4 = null.

sample : if got 2 item
item 1 : need to display 4 row
row 1
row 2
row 3
row 4

item 2 : need to display 2 row only
row 1
row 2

anyone can help me ? thankx

Crystal Report - Multiple Column Section
I am trying to get a report going with a vertical section divider, so I can have two different columns coming from two different tables...I did set it up with two tables, but if the data in the first column has 3 entries, and the other only has one, the one entry will be duplicated for the 2 remaining fields...

Im not sure im making any sense, but what i want to do is have an invoice that has a material column and a labor colum.

There can be 10 material entries, but only one labor.

I want it to display like this:

Mat1 Lab1

So, that lab1 doesnt repeat to fill in the empty rows...
Anybody can help?

How Do Split Details Section In Crystal Report ?
My program uses crystal report (buddled with vb5) to print out a hard copy of computer generated receipt. My point is how can I split the Details Section into 2 ?

Let say, a record of receipt consists of
Recepit No, Name, Course, Payment fields in general, I use computer paper to print out the receipt, I found that the width of paper can be filled up with 2 records, for an example

Receipt No: 0000001 Receipt No: 0000002
Name: John Name: Waye
Course: Win98 Course: Access
Payment: Cash Payment: Cheque

How to do with the setting in Crystal report so that I can print out the receipt as Shown above ?I can only generate the same record within the Details Section no matter how many Receipt No is inserted into the section. Like the following,
Receipt No: 0000001 Receipt No: 0000001
Name: John Name: John
Course: Win98 Course: Win98
Payment: Cash Payment: Cash

Font Color Of Section In Crystal Report
I am using Crystal Report 8.0 with VB6. My problem is that I want to change the foreground color of the section. As it is possible to change the background color but my requirement is to change its foreground color at runtime. Help in this regard is appreciated.

Crystal Report: Suppressing Blank Area In Section
In my Crystal Report's Details Section, the blank space after the last line is unnecessarily printed and this disturbs page length settings. How to delete the unnecessary lines below the last text in the Details Section, so that they are not printed as Blank.

Crystal Report Printing Problem - Sorry I Might Have Posted In It VB Section
Crystal Report Printer does not respond
I have a Crystal Report printing problem on the Network printer.
I am using CR 7.0

I have the following code Snippet:

CrystalReport1.ReportFileName = gReportsPath + "" + "Report1.RPT"
CrystalReport1.ReportFileName = gReportsPath + "" + "Report1.RPT"
......... bla bla bla
CrystalReport1.Destination = 1
CrystalReport1.Formulas(0) = " "
CrystalReport1.Formulas(0) = "Status = " + "'" + gsStatus1 + "'"

......... bla bla bla

The problem is
-- the report does not print or display from the VB code
-- it prints very well from the Crystal Report menu.
-- I even put the printer's IP address and name on the property of the CR Control in my VB code.

I appreciate any help or suggestion what might be wrong in my code or the report reference

Thank you very much.


Crystal Report Printing Problem - Sorry I Might Have Posted In It VB Section
Crystal Report Printer does not respond
I have a Crystal Report printing problem on the Network printer.
I am using CR 7.0

I have the following code Snippet:

CrystalReport1.ReportFileName = gReportsPath + "" + "Report1.RPT"
CrystalReport1.ReportFileName = gReportsPath + "" + "Report1.RPT"
......... bla bla bla
CrystalReport1.Destination = 1
CrystalReport1.Formulas(0) = " "
CrystalReport1.Formulas(0) = "Status = " + "'" + gsStatus1 + "'"

......... bla bla bla

The problem is
-- the report does not print or display from the VB code
-- it prints very well from the Crystal Report menu.
-- I even put the printer's IP address and name on the property of the CR Control in my VB code.

I appreciate any help or suggestion what might be wrong in my code or the report reference

Thank you very much.


Detail Section Sort In CR
i m using crystal report 7.0. i have created 2 groups, problem is that my detail section is not sorted. how can i sort it. i m usnig crystal report ocx control.
for example

Main Group
Sub Group
(detail) 01--- Name----Address----Phone
05---Name---- = ----------=
03--- = ------= ----------=


here my detail section is not sorted, i have created my groups then how can i sort detail section.


My Detail Section Is Not Showing
hi.. i dont know what's wrong with my datareport..its not showing the detail was working before..but i have change something and right now, i can't get it to work.. i have checked on the has something there..i have tried to run the query under stored builder..and it shows me all the information in the table..please help.. it is showing me the page header and footer..but not the detail section..

i have to put a rptlabel..still its not showing in the detail section but it does on page header.

Detail Section Problem
How to Fix the size of the detail section in Crystal Report 8.0

Access Forms: Detail Section
OK .... I'm working on a form in Access ... all records are displayed on the same page at the same time in the detail section ... to make it easy, lets say there are only 2 textboxes (one for Start_Date and one for End_Date), a couple of labels, and one dynamic rectangle (boxGrowForDate) which should change size according to the difference of dates (in days) in the 2 textboxes.
The rectangle works fine in the OnFormat event in a report and it displays fine for every record. When i put the same code (see below) in the OnCurrent event of a Form, however, it does not work right. The rectangle is the same width for every record that you can see on the page (shows same # of days or same width for every record depending on which record is currently selected). But it should be different width depending on each records' difference in dates.
I hope this is somewhat clear (i tried) . Any suggestions on how i could access each record individually to make the rectangle display the right difference in days for each record would be greatly appreciated.


Private Sub Form_Current()

Dim intStartDayDiff As Integer
Dim intDayDiff As Integer
Dim sngFactor As Single

sngFactor = Me.boxMaxDays.Width / mintDayDiff

If Not IsNull(Me.Start_Date) And Not IsNull(Me.End_Date) Then
Me.boxGrowForDate.Visible = True
Me.lblTotalDays.Visible = True
intStartDayDiff = Abs(DateDiff("d", Me.Start_Date, mdatEarliest))
intDayDiff = Abs(DateDiff("d", Me.End_Date, Me.Start_Date))

If intStartDayDiff = 0 Then intStartDayDiff = 1
With Me.boxGrowForDate
.Left = Me.boxMaxDays.Left + (intStartDayDiff * sngFactor)
.Width = intDayDiff * sngFactor
End With
Me.lblTotalDays.Left = Me.boxGrowForDate.Left
Me.lblTotalDays.Caption = intDayDiff & " Day(s)"
Else '
Me.boxGrowForDate.Visible = False
Me.lblTotalDays.Visible = False
End If

End Sub

Conditional Formatting Detail Section
I have a situation where I need to toggle the textBox font formatting between bold and normal for all text boxes in the detail section of an Access 2000 report. If the value of one of the fields in the detail section = a specific range of values, then I want that entire line of detail to stand out via bold text. If the value is not within that range then I want the font to remain normal. If the Is there an easy way to achieve that goal?

Serial No (Record No) In Detail Section
Can anyone tell How to give serial number in the detail section of a data report in design time as well as at runtime. In Runtime , I am using an SQL command to populate the master "Command" of the Data Environment.

The result should come like this

Group Header ............................ Date
Sl.No. Name Amt Due
1) xxxxxxxxx 99999 999999
2) xxxxxxxxxx 99999 9999999

Here the number should be automatically given in the data report.

Please help.

Datareport, Choice In Détail Section ?
Hi !
In the datareport'détail section' , how can we make a choice so that we fill a text box with différentes values depending on our recordset field ? To be easier to understand here what i tried :

With DR03.Sections("Section1").Controls 'DETAILS
.Item("Text1").DataField = Rst02.Fields("nom").Name
.Item("Text2").DataField = Rst02.Fields("prenom").Name
.Item("Text3").DataField = Rst02.Fields("MiseHS").Name
If .Item("Text3").DataField = "-1" Then
.Item("Text3").Value = "Yes"
.Item("Text3").Value = "No"
End If
End With

This generate an error "property none supported"
So i tried this :

With DR03.Sections("Section1").Controls 'DETAILS
.Item("Text1").DataField = Rst02.Fields("Nom").Name
.Item("Text2").DataField = Rst02.Fields("Prenom").Name
If Rst02!MiseHS = -1 Then
.Item("label13").Caption = "Yes"
.Item("label13").Caption = "No"
End If
End With

I replaced the textbox by a label but this works only for the first record of my datarecorder.
Ps, I don't use dataenvironnement but Datarecorder

Copyright © 2005-08, All rights reserved