Assaining a value to a textbox dynamically

R

Ram

Hi,

I have to generate a report by processing a certain column
values of each row of a recordset and send the summary
values to different textBoxes to display on my report. Is
there a way to assaign a value to textBox dynamically?

Thanks,
ram
 
D

Duane Hookom

You can use code in the On Format event of the section containing the
unbound text boxes.

Me.txtStartDate = rs("StartDate")
 
M

Marshall Barton

Ram said:
I have to generate a report by processing a certain column
values of each row of a recordset and send the summary
values to different textBoxes to display on my report. Is
there a way to assaign a value to textBox dynamically?
Click to expand...


Sure, just use the text box section's Format event to set
it.

Me.textbox = somevalue
 
R

Ram

I have to send a calculated value which is in a field
variable defined in the report module. When I try to
assaign this an error message occures
"can't reffera field when it doesn't have control
 
Top