Results 1 to 3 of 3
  1. #1
    LostInAccess is offline Novice
    Windows 7 64bit Access 2010 64bit
    Join Date
    Jun 2012
    Posts
    6

    Form Back Color, screen only?

    Hi All,

    I would like to know how to have the 'back color' of my Form 'Screen Only'. I am trying to print this form via a dot matrix printer and I only require the info from the Form (some labels, so data only print doesn't work). All the other fields and elements of my Form have the property to select "Display When - Screen Only" except for the 'back color'. I need the back color on the screen to make it user friendly, but I don't want it to print. I'm printing the Form because it has some fields that are query based and others that require the user to enter data and it is laid out exactly as I need it to print (so moving to a report won't be easy).

    Any suggestions?


  2. #2
    pbaldy's Avatar
    pbaldy is offline Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,521
    As mentioned on your other thread:

    I only print reports; you have a lot more control over the format when printing a report.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Missinglinq's Avatar
    Missinglinq is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    May 2012
    Location
    Richmond (Virginia, not North Yorkshire!)
    Posts
    3,018
    FYI, you can easily convert your Form to a Report

    1. Open the Database containing the Form.
    2. Click the name of the Form in the Navigation Pane.
    3. Click the Microsoft Office Button.
    4. Point to Save As
    5. Click on the Save Object As.
    6. Click in the Save “Form_Name” To text box and enter a name for your Report.
    7. Use the drop-down arrow in the 'As' text box and select Report from the list
    8. Click on OK.

    Now go into Design View for the Report and make any needed changes.

    Linq ;0)>
    The problem with making anything foolproof...is that fools are so darn ingenious!

    All posts/responses based on Access 2003/2007

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

Similar Threads

  1. Replies: 4
    Last Post: 05-21-2012, 08:21 AM
  2. Replies: 8
    Last Post: 04-26-2012, 10:13 AM
  3. Report Back Color formatting
    By RayMilhon in forum Reports
    Replies: 5
    Last Post: 02-07-2012, 03:20 PM
  4. Alternate Back Color not working properly
    By kolarbr in forum Access
    Replies: 7
    Last Post: 08-30-2011, 10:16 AM
  5. Back color update issue
    By GraemeG in forum Programming
    Replies: 3
    Last Post: 03-21-2011, 11:32 AM

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