Text box appearing once in footer

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a report in which I have a footer that has many lines of data. I want
the first line of the first footer to show a $ sign. I though about adding a
unbound text box that has just "$", but how do I tell the report I want the $
to appear just once in the entire report?

I hope this makes sense.
 
I have a report in which I have a footer that has many lines of data. I want
the first line of the first footer to show a $ sign. I though about adding a
unbound text box that has just "$", but how do I tell the report I want the $
to appear just once in the entire report?

I hope this makes sense.
Click to expand...

Which footer?
The Page Footer?
Code the Page Footer Format event:
[LabelWith$].Visible = Me.[Page]=1
 
No ... It's a control footer "Major". I tried putting it in the Major Footer
format event

[Label20].Visible=Me.[Major]=1

but when I attempt to open the report, it's asking for the macro "Label20".
Maybe I'm putting it in the wrong place. I'm going to properties for the
"Major Footer" and adding in "Events" "On Format"

fredg said:
I have a report in which I have a footer that has many lines of data. I want
the first line of the first footer to show a $ sign. I though about adding a
unbound text box that has just "$", but how do I tell the report I want the $
to appear just once in the entire report?

I hope this makes sense.
Click to expand...

Which footer?
The Page Footer?
Code the Page Footer Format event:
[LabelWith$].Visible = Me.[Page]=1
Click to expand...
 
No ... It's a control footer "Major". I tried putting it in the Major Footer
format event

[Label20].Visible=Me.[Major]=1

but when I attempt to open the report, it's asking for the macro "Label20".
Maybe I'm putting it in the wrong place. I'm going to properties for the
"Major Footer" and adding in "Events" "On Format"

fredg said:
I have a report in which I have a footer that has many lines of data. I want
the first line of the first footer to show a $ sign. I though about adding a
unbound text box that has just "$", but how do I tell the report I want the $
to appear just once in the entire report?

I hope this makes sense.
Click to expand...

Which footer?
The Page Footer?
Code the Page Footer Format event:
[LabelWith$].Visible = Me.[Page]=1
Click to expand...
Click to expand...

Do you get just the one Major Group Footer on a page?
Code the Group Footer Format event:
[Label20].Visible=Me.[Page]=1

Do NOT change Me.[Page] = 1 to Me.[Major] = 1 as you did above.
Your checking to see if [Page] (the page number) = 1, not the value of
[Major].


If you can get more than one Major group footer on a page, code the
Major Group Footer PRINT event:

Static intX as Integer
[Label20].Visible = intX = 0
intX = 1
End If

Note that intX is Dimmed as Static.
 
That worked like a champ!!! Thanks so much for your help. FYI, I did it on
the print event since, yes, I did have several major groups.

Thanks again.

fredg said:
No ... It's a control footer "Major". I tried putting it in the Major Footer
format event

[Label20].Visible=Me.[Major]=1

but when I attempt to open the report, it's asking for the macro "Label20".
Maybe I'm putting it in the wrong place. I'm going to properties for the
"Major Footer" and adding in "Events" "On Format"

fredg said:
On Mon, 10 Apr 2006 09:30:02 -0700, margaret wrote:

I have a report in which I have a footer that has many lines of data. I want
the first line of the first footer to show a $ sign. I though about adding a
unbound text box that has just "$", but how do I tell the report I want the $
to appear just once in the entire report?

I hope this makes sense.

Which footer?
The Page Footer?
Code the Page Footer Format event:
[LabelWith$].Visible = Me.[Page]=1
Click to expand...
Click to expand...

Do you get just the one Major Group Footer on a page?
Code the Group Footer Format event:
[Label20].Visible=Me.[Page]=1

Do NOT change Me.[Page] = 1 to Me.[Major] = 1 as you did above.
Your checking to see if [Page] (the page number) = 1, not the value of
[Major].


If you can get more than one Major group footer on a page, code the
Major Group Footer PRINT event:

Static intX as Integer
[Label20].Visible = intX = 0
intX = 1
End If

Note that intX is Dimmed as Static.
Click to expand...
 
Back
Top