Hi Everyone,

I am having a friday brain cramp.

I need to change the caption of a lable on a report at run time. I have done this in the past, I just don't remember how or where.

From vba, I have opened the report in design view, now I just need to reference "lblHeading" and change the caption.

Does anyone have a clue as to how to make that change?

Thanks

Mike

Mike
EchoVue.com

__________________
Mike
EchoVue.com

What do you want to put in the label? You can add code to change the label, or you can use a text box instead and then push the value from your code. That would be easier than using the label, and you can format the text box to look the same way.

HTH


mmcdonal

Hi Mike,

I am just putting a header on the report - In this case 'February 2006' but I want it to be dynamic, based on user input. I did this earlier in the week, and then is a state of mind not unlike where I am currently, I saved the old version of the file over the changes that I had made - Grrrrrr!

What code would you use to change the label? And would you put this on the form or the report?

Thanks

Mike
EchoVue.com

I have done this in forms and reports and used calcualations, field values etc like this:

Me.txtMyTextBox = Date

For Example

Or Me.txtMyTextBox = Me.Field + Me.Field1

etc.

I also use text boxes on headers where I know the user is opening the report using parameters. Then I will just put the field name in the text box on the header and format it like th rest of the banner label like

Label[User Report for] TextBox[UserName]

HTH


mmcdonal

Thanks!! I got it working. I think that while I am ahead, now may be the right time to call it a day!

Mike

Mike
EchoVue.com