Results 1 to 4 of 4
  1. #1
    paradox6996 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    4

    Printing from a form


    I need help creating a conditional macro that chooses from a Group Label Size "Big" or "Small". If the big optionis selected than optgrplabelsize = 1 and if the small option is selected optgrplabelsize = 2. How would I create the macro to print from one report if the big option is selected or print from another report if the small option is selected.

    Thanx for the help, let me know if additional detail is needed.

    Edit: Be nice if I could just delete this. I figured it out.

  2. #2
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Edit: Be nice if I could just delete this. I figured it out.
    Instead of deleting the post if may be helpful to someone else if you post the solution.

  3. #3
    paradox6996 is offline Novice
    Windows 7 64bit Access 2007
    Join Date
    May 2011
    Posts
    4
    Conditional:
    Code:
    [Forms]![frmPrintLabels]![optgrpLabelSize]=1
    Action: Open Report, Args: lblBigLabels, Print Preview, , , Normal

    /Stop Macro

    Conditional:
    Code:
    [Forms]![frmPrintLabels]![optgrpLabelSize]=2
    Action: Open Report, Args: lblSmallLabels, Print Preview, , , Normal

    For the Argument actions when opening the report, just change the view to Print Preview.

    Paradox(>")>

  4. #4
    SoftwareMatters is offline Access VBA Developers
    Windows XP Access 2003
    Join Date
    Mar 2009
    Location
    Dorset
    Posts
    274
    Thank you

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Printing report from Form
    By cotri in forum Access
    Replies: 8
    Last Post: 05-24-2013, 12:01 PM
  2. Tabbed Form & Printing...
    By nchesebro in forum Forms
    Replies: 3
    Last Post: 12-20-2010, 03:03 PM
  3. Printing a form
    By l8poulse in forum Forms
    Replies: 1
    Last Post: 08-19-2010, 06:29 AM
  4. form printing
    By nkuebelbeck in forum Forms
    Replies: 4
    Last Post: 04-01-2010, 01:39 PM
  5. Printing Form
    By linjoye in forum Reports
    Replies: 1
    Last Post: 02-19-2010, 08:09 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums