Handle Change

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

Guest

Hi all,

Is there a good way to handle formatting changes like the style in Excel?

CLara
 
Hi Clara,

unlike Excel and Word, Access does not use Styles


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Hi Crystal,

Even though there is no Style feature in Access, What is your method to
control format changes on a report

Clara

thank you so much for your help
 
customize form/report design toolbar
---


Hi Clara,

you're welcome ;)

"What is your method to control format changes on a report?

just to make them (sorry, probably not what you want to hear)

there are a few tricks I use, though, to make formatting faster...

1. double-click a control handle to do a best-fit

2. adjust width and height using property sheet. sometimes I drag to
get a relative size, then adjust because I like things to be exact

3. line top and left using buttons you can add to toolbars (I sometimes
use property sheet to adjust these as well)

4. select several controls at once by clicking and dragging either in
vertical ruler or horizontal ruler -- anything that touches the extended
line/rectanglar region will be selected

5. click in a ruler to get all controls touched by the extended line --
also great for reducing margins :)

* CUSTOMIZING YOUR FORM/REPORT DESIGN TOOLBAR:

when you are in the design view of a form or report, RIGHT-CLICK in a
gray area to the right of your menu bar or an icon bar

choose "Customize" from the shortcut menu

in the dialog box...

choose the *Commands* tab

Category --> *Form/Report Design*

slide these icons to the Form Design toolbar:
(they are located about 3 "screens" down in the Commands list)

Align Right -- must have >1 control selected to be enabled
Align Left -- "
Align Top -- "
Align Bottom -- "
Bring To Front
Send To Back

If you don't know what these icons do, while the customize window is
open, click on the DESCRIPTION command button for each one to see what
is does.

to be efficient, the Align button are a MUST for form and report design

the Bring To Front and Send To Back are nice to have too -- since
everything is "layered" and this gives you control on the order

~~~~~~~

It is also a good idea to open the property sheet
(from the menu --> View, Properties)

on the Format tab, you can set values such as width, height, left, top, ...

~~~~~~~

in order to align, you have to have more than one control selected

to select multiple controls:

1. click and drag an imaginary line (or rectangle) touching every
control you want to select and then let go of the mouse

OR

2. click (and drag if desired) in the vertical ruler to select
everything on that extended horizontal line (or rectangle)

OR

3. click (and drag if desired) in the horizontal ruler to select
everything on that extended vertical line (or rectangle)

OR

4. click the first object and then SHIFT-CLICK objects to toggle their
selection status


Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Thank you very much for your info!

Do you know anything about Crystal Reports? Compared to Access reporting,
which one is better?

Clara

thank you so much for your help
 
Hi Clara,

you're welcome ;)

I do not use Crystal Reports. From what I have heard from those that
use both, the Access reporting tool seems have more features and is
easier to use. I guess it really depends on your application and what
you are trying to do.

Warm Regards,
Crystal
*
(: have an awesome day :)
*
MVP Access
Remote Programming and Training
strive4peace2006 at yahoo.com
*
 
Back
Top