[Resolved] how to modify a textbox value inside a report

[asmdev]

hi, i wish to ask,
how is it to modify a textbox value which is located in a report?

i guess my problem is, how to accessing those control from various location and to modify them from various location. anybody who got experience plez light me a little bit thanks in advance.

[RobDog888]

Use this procedure in the Report class.

Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer)

What do you mean to modify them from various locations?
If your not running the report then why modify it?

[asmdev]

thanks rob
let me desc my problem a byte, so that you could see if there any wise alternative you wish to suggest to this problem.


i got a query which dumps out a list of student by their registration date.
so, i create a report based on this query and i put this (below)

[Please insert the registration date you wish to search]

on the registerationDate field criteria.

so, when user run that report, it would prompt the user to insert a date so that it would prints out only the list for that particular day.

what i intend to do is,
1. to put the date (the one the user key in) into the report so that after print out, they know the list are based on what searched registration date.



hope this would make more easier for you to help on this topic.

thanks in advance

[RobDog888]

Yes, allot better now.

You can pull the field "[Please insert the registration date you wish to search]" into your report from the field chooser in the report design view mode.
Then set the textbox's controlsource to that field.

[asmdev]

thanks rob
your suggestion has solved my problem.
thanks for your help

[asmdev]

well, just wanna know, let say if the textbox is not bound to any data source, is that still possible for us to put some text into that textbox (in report) ?

[RobDog888]

Yes, in post #2, you can set the value for an unbound textbox to ???