 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / Reports / Printing / January 2007Label Value
I need to pull the Value of a Label on a form to a Report. I tried putting this on the command button of the form after the report opens but it doesn't work, I assume that its a timing issue, and unlike a textbox there isn't a control property to put a value in. Reports!rptCheck!LblDiscount.Caption = Forms!frmCheckPreview!LblDiscount.Caption Thanks DS Is the label caption created in a way that you cannot reproduce on the report? I have not tried what you are asking, but I assuming the form is still open I expect you could set the label's caption in the Print event of the report section (e.g. the Detail section's Click event if the label is in the Detail section): Me.lblDiscount.Caption = Forms!frmCheckPreview!LblDiscount.Caption. >I need to pull the Value of a Label on a form to a Report. I tried putting >this on the command button of the form after the report opens but it [quoted text clipped - 6 lines] > Thanks > DS I made a Text Box with this in the control source. =[Forms]![frmCheckPreview]![LblDiscount].[Caption] This works. The form is closed when the report prints. Thanks DS > Is the label caption created in a way that you cannot reproduce on the > report? [quoted text clipped - 14 lines] >> Thanks >> DS >I made a Text Box with this in the control source. > =[Forms]![frmCheckPreview]![LblDiscount].[Caption] [quoted text clipped - 21 lines] >>> Thanks >>> DS > I need to pull the Value of a Label on a form to a Report. I tried putting > this on the command button of the form after the report opens but it doesn't [quoted text clipped - 6 lines] > Thanks > DS Work it from the Report end. Code the Report's Report Header Format event: Me.[lblDiscount].Caption = Forms!frmCheckPreview!LblDiscount.Caption The form must be open when the report is run.  SignatureFred Please respond only to this newsgroup. I do not reply to personal e-mail The form is closed when the report is run. Thanks DS >> I need to pull the Value of a Label on a form to a Report. I tried >> putting [quoted text clipped - 16 lines] > > The form must be open when the report is run. Change the label in the report to a text box. Put your reference to the form's label in the Control Source of the text box: =Forms!frmCheckPreview!LblDiscount.Caption SignatureDave Hargis, Microsoft Access MVP > I need to pull the Value of a Label on a form to a Report. I tried putting > this on the command button of the form after the report opens but it doesn't [quoted text clipped - 6 lines] > Thanks > DS |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.