Hi all,

I made a very nice looking report for one of my clients, and he now asks me
to put an arrow in the report header. I agree it would make the layout
better.

The easy answer would be to say that Access does noet support this, but
before I do that: Does anyone know if this is at all possible ? (even though
the Microsoft boys did not put it in) [A2007]


Any suggestions ?

Thanks in advance,

Bas Hartkamp

HS Hartkamp wrote:


There's some controls that can use the picture property. Might not be
what you need.

No, but what you could do is launch a form with the data sheet as a
sub-form.

The user could set the sorting and filter options using that drop down
interface to get the data exactly he way they want....

The, in the top of part of the form, you have a button to launch the
report...


dim strReport as string

strReport = "report Name goes here"

docmd.OpenReport strReport,,,me.SubForm.Form.Filter
reports(strReport).Orderby = me.SubForm.OrderBy
reports(strReport).Orderbyon = true


--
Albert D. Kallal (Access MVP)
Edmonton, Alberta Canada
pleaseNOOSpamKallal (AT) msn (DOT) com

you can draw a plain and simple arrow by positioning three line objects, in
report Design view, the same way you'd draw an arrow on a piece of paper,
using three lines.

hth


"HS Hartkamp" <hartkamp (AT) wanadoo (DOT) nl> wrote

"HS Hartkamp" <hartkamp (AT) wanadoo (DOT) nl> wrote

Others have assumed that you want the arrow to have some functionality
(which you did not state). If you do not, then there are a number of fonts
(of symbols) that have various arrow characters. Depending on the
(unstated) details, you might have to restructure your controls and labels
to use a different font for that one character.

Larry Linson
Microsoft Office Access MVP



__________ Information from ESET Smart Security, version of virus signature database 4025 (20090421) __________

The message was checked by ESET Smart Security.

http://www.eset.com