RE: Add ONE variable word to report header

Now is around the time when I start to fear I'm trying my advisor's patience.
I tried to do what you said and the report still won't open, except in design
mode. This is what I now have in my Open Event:

Private Sub Report_Open(Cancel As Integer)
If MgbBox("Is This A Revision", vbQuestion + vbYesNo) = vbYes Then
Me.Label4.Caption = Me.Label4.Caption & " Revision"
End If
End Sub


Klatuu wrote:
A couple of things. First, you Report Title should be a Lable control. In my
haste, I named it as if it were a text box, sorry. Anyway, I just did a
quick test and it does work. What you need to do is use the name of your
label control in the code instead of mine. It was only an example.
So change txtReportTitle to whatever the name of your control is. I think
that should work, let me know.

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-reports/200603/1
.

Relevant Pages

  • Re: More problems with Multiselect List Boxes
    ... multi-select box asking which "employee levels" I want in the report, ... In the Open event for each such report, ... Dim strRecordSource As String ...
    (microsoft.public.access.formscoding)
  • Re: Im missing the boat on something simple!
    ... I rebuilt the entire query, form and report to be sure it was not something ... The employeeID and Name fields are taken from the query but are supplied ... The Param form does not open with the report. ... Code the Report's Open Event: ...
    (microsoft.public.access.reports)
  • Re: set recordsource of subreport using VBA
    ... reference to the property Form/Report. ... ControlSource property from the parent report. ... You said RecordSource, ... yet exist at the time of the main report's Open event. ...
    (microsoft.public.access.reports)
  • Re: Im missing the boat on something simple!
    ... I rebuilt the entire query, form and report to be sure it was not something ... The employeeID and Name fields are taken from the query but are supplied ... The Param form does not open with the report. ... Code the Report's Open Event: ...
    (microsoft.public.access.reports)
  • Re: Im missing the boat on something simple!
    ... I rebuilt the entire query, form and report to be sure it was not something ... The employeeID and Name fields are taken from the query but are supplied ... The Param form does not open with the report. ... Code the Report's Open Event: ...
    (microsoft.public.access.reports)
Loading