Page Label

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Chris L - 30 Jan 2007 08:23 GMT

Hi,

Does anyone know how to add a page label (a label on the right side of every
page). In MS Word, I can add the label (a picture) as part of footer, i.e. by
dragging the picture in textbox to the right side of the page but still part
of a footer.

In Access I can't add it into the details section as I have a grouping and I
can't fix the the position. I also can't add it into the footer as it will
consume space (no text can be added to the left of the label). Does anyone
have an idea how to resolve this?

Thank you,
Chris

Reply to this Message

Allen Browne - 30 Jan 2007 08:43 GMT

The Report has a Picture property.
Could you use that?

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Does anyone know how to add a page label (a label on the right side of
> every
[quoted text clipped - 9 lines]
> consume space (no text can be added to the left of the label). Does anyone
> have an idea how to resolve this?

Reply to this Message

Chris L - 30 Jan 2007 09:26 GMT

Hi Allen,

Thank for the reply. I tried to use the Picture property, but the
positioning of the picture at certain location (just above the page number)
cannot be done . I also only want to label in the odd pages, which also not
possible...

Regards,
Chris

> The Report has a Picture property.
> Could you use that?
[quoted text clipped - 12 lines]
> > consume space (no text can be added to the left of the label). Does anyone
> > have an idea how to resolve this?

Reply to this Message

Allen Browne - 30 Jan 2007 10:39 GMT

There is a Page event that lets you place text and lines on a page, but I've
never tried it for images.

Or perhaps someone else has a suggestion.

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi Allen,
>
[quoted text clipped - 28 lines]
>> > anyone
>> > have an idea how to resolve this?

Reply to this Message

Chris L - 31 Jan 2007 01:51 GMT

Hi Allen,

Could you guide me how to place the text on the page. Most of the sample
codes deal with the line in the page event. Should I create the text box in
the design form and just reposition it in page event?

Regards,
Chris

> There is a Page event that lets you place text and lines on a page, but I've
> never tried it for images.
[quoted text clipped - 32 lines]
> >> > anyone
> >> > have an idea how to resolve this?

Reply to this Message

Allen Browne - 31 Jan 2007 05:38 GMT

Basic example:

Private Sub Report_Page()
Me.CurrentX = 1440
Me.CurrentY = 1440
Me.Print "G'day"
End Sub

Signature

Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

> Hi Allen,
>
[quoted text clipped - 5 lines]
> Regards,
> Chris

Reply to this Message