Toolbar on Report

  • Thread starter Thread starter bURT rOSNER
  • Start date Start date
B

bURT rOSNER

Help,

I created a report and in the properties I assigned a
custome toolbar that I created. When I bring the report
up in Print Preview the toolbar shows up, but is not
enabled. Without going into the sordid details of what I
tried to do with no success. Can someone share with me
how I can get the toolbar enabled.

Thanks,

Burt
 
I would assume that you created a NEW menubar (you do NOT want to use the
built in ones, as many are attached/set to load only in certain
situations..and besides...they don't copy when you move the application to
another pc).

So, make new custom menu.

After you make your nice cute new menu bar, you then specify the report to
load this tool bar in the "other" tab.

All my reports also have a docmd.Maximize in the on-open event, since that
is what 99 out of 100 users prefer anyway (they like seeing as much as the
report as possible anyway). The form that calls the report has the min/max
buttons turned off, and thus the form is NOT maximized, or effected by the
reports max setting at all.

Here is a screen shot of a report with my custom menu bar:

http://www.attcanada.net/~kallal.msn/test/bu1.gif
 
-----Original Message-----
I would assume that you created a NEW menubar (you do NOT want to use the
built in ones, as many are attached/set to load only in certain
situations..and besides...they don't copy when you move the application to
another pc).

So, make new custom menu.

After you make your nice cute new menu bar, you then specify the report to
load this tool bar in the "other" tab.

All my reports also have a docmd.Maximize in the on-open event, since that
is what 99 out of 100 users prefer anyway (they like seeing as much as the
report as possible anyway). The form that calls the report has the min/max
buttons turned off, and thus the form is NOT maximized, or effected by the
reports max setting at all.

Here is a screen shot of a report with my custom menu bar:

http://www.attcanada.net/~kallal.msn/test/bu1.gif


--
Albert D. Kallal (MVP)
Edmonton, Alberta Canada
(e-mail address removed)
http://www.attcanada.net/~kallal.msn


.
Thanks Albert. I'll try that. Burt
Click to expand...
 
Albert,

I did what you said. But, when I went to the "Other" tab
in the Report Property and selected my Toolbar, it still
came up unenabled. The problem is how to enable it.

Burt
 
Albert,

I did what you said. But, when I went to the "Other" tab
in the Report Property and selected my Toolbar, it still
came up unenabled. The problem is how to enable it.

Burt
Click to expand...

Hum, something is not right here ;-)

Is the whole menu disabled?

Can you add a new custom options...are they active?

(add anew options to the menu and have it run some code like:

msgbox("This is a test")

As mentioned, are the buttons on the tool bar being grabbed from other tool
bars...or are you creating your own buttons from scratch?

Perhaps you should try making a super simple menu bar with just a few
options..and try specify that one for the report.

Also, Does the menu bar work if you show it first (just right click the menu
bars..and show YOUR menu before you run the report). (So, , show the menu
bar, and don't even specify it for the report in the "other" tab. Is the
menu bar always disabled...even when the report is not opened?
 
Albert,

I was the one that was disabled. The Menubar works just
fine. I was trying to use the Font Type, Font Size menu
options and it appears those commands don't enable the way
I was using them.

What I really want to do is create a report and have the
user (my client) control the font style, font size, etc.
I thought if I made a menubar with those commands on it
and attached it to a report everything will work. It
doesn't. Would you have any suggestions as to how I can
accomplish this?

Thanks, for bearing with me,

Burt
 
Excel has always had some nice options like "fit" to page when printing. (we
don't have that fit/shrink option in ms-access).

The reports in ms-access are quite fixed in that regards.

They are what they are!

You can certainly add the "zoom" command button to a menu bar for the report
when in preview mode. This will allow the person viewing the report to zoom
in/zoom out..but that does NOT effect how the report prints.

You might allow some changing of the fonts...but I don't think it is very
workable for reports of any real complexity. Some printer drivers do allow
some shrink type options...but they would not be part of ms-access.
 
Albert,

I think there has to be a way to predefine what the font
size and style can be. If I can go to the properties of a
report and change the fonts, I believe there is a way to
change the fonts in VBA. E.G. TextBox1.Visible = True.

Maybe you can point me in the direction to write the
correct syntax.

Thanks for your help,

Burt
 
Back
Top