how can change one control in whole rows

[smahdih]

dorod (means hi)

i have one problem, in a report insert new textbox nemed newLeadTime , in on load event report typed :

me.NewLeadTime.value = me.leadTime.value * 2

attach the result



i want every row change by own leadTime , how can do this?

[pbaldy]

Rather than code, why not just have the second textbox have a control source of:

=[leadTime] * 2

To do it in code, you'd put it in the detail format event.

[smahdih]

Rather than code, why not just have the second textbox have a control source of:

=[leadTime] * 2

To do it in code, you'd put it in the detail format event.

forget the leadTime* 2 , indeed i have a Date/Time field in report and i want convert it to shamsi calender, i wrote vb code for conversion but every time load report just the last row convert to shamsi and other row is same last row.

How i can convert each row?

[pbaldy]

did you miss this?

To do it in code, you'd put it in the detail format event.

[smahdih]

did you miss this?

sorry, i try it but not opearte, display a empty textbox in report

[pbaldy]

Not sure what to say. If the code works on one record in the load event it should work on every record in the detail format event.