rptTextBox in Page Header

[kimtp]

I have a field containing a year that I would like to place in the page header. However, I am unable to place a rptTextBox in the header to pick up the field.

Also, have been unsuccessful in trying to do the .caption that can be done in forms.

Any ideas on how to solve this problem is appreciated.

Thanx.

Kim

 

[KenReay]

HI

You do not say where the field containing the year is defined, is it on a form, is it a global varaible in the report?

But if you put code in the onformat event of the report header you should be able to do either .caption, or txt box solution so:

(In On Format event of report header)

txtYear = GlobalYear
txtYear = Forms!MyYear
lblYear.Caption = GlobalYear
lblYear.Caption = Forms!MyYear

is this anything like you have tried, (with your own field names of course) and what was the result (be a bit more explicit that 'did not work') Regards

Ken Reay
Freelance Solutions Developer
Boldon Information Systems Ltd
Website needs upgrading, but for now -

http://www.kenneth.reay.btinternet.co.uk

UK

 

[kimtp]

I was referring to the report header in a VB application and not in the Access Reports section. I have not found a way to use an Access made report in VB6. If you know, please share.

thanx.

Kim