Results 1 to 6 of 6
  1. #1
    Traceyann is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    7

    Change Text in Parameter Dialogue Box

    Hi
    Hope somebody is able to help me with this? I have a parameter query set up to open a report from a form via a command button(print preview report)to show/print a single record that I am viewing in a form.
    Explanation:- Form called "Purchase Orders" I enter a new Purchase Order then want to print preview this particular record so have set up a report, I then click the command button on the form "print preview" and the parameter dialogue box pops up .This all works very well but wondered if there is a way to change the text that appears in the parameter dialogue box to make it user friendly ie "Enter Purchase Order Number"


    This is what I have in the criteria of the query "[Forms]![Purchase Orders]![ Purchase Order Number]"
    Thanks in Advance

  2. #2
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Would this work for you?

    BaldyWeb wherecondition

    Then the user doesn't have to enter anything.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  3. #3
    Traceyann is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    7
    Thank you but I have no experience of code at all although I have tried to get my head around it a wee while ago to no avail. Thanks for the help though!

  4. #4
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    Well if you're getting a parameter prompt, either the form isn't open or something is spelled wrong.
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

  5. #5
    Traceyann is offline Novice
    Windows XP Access 2010 64bit
    Join Date
    Aug 2012
    Posts
    7
    The parameter prompt is correct -I just want to to be able to change the text in it to something more user friendly?

  6. #6
    pbaldy's Avatar
    pbaldy is online now Who is John Galt?
    Windows XP Access 2007
    Join Date
    Feb 2010
    Location
    Nevada, USA
    Posts
    22,641
    I'm confused, because you can have any text you want on the form. It sounds like you're referring to a form but not actually using one. If that's the case change it to:

    [Enter purchase order number]
    Paul (wino moderator)
    MS Access MVP 2007-2019
    www.BaldyWeb.com

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

Similar Threads

  1. Parameter Query/Report Question to Count Text
    By Lettyg82 in forum Reports
    Replies: 6
    Last Post: 08-13-2012, 03:47 PM
  2. Text Box wont allow me to change formatting
    By Chelcone in forum Forms
    Replies: 14
    Last Post: 04-20-2012, 07:33 AM
  3. Need a function to change queried text
    By rjohnson in forum Queries
    Replies: 2
    Last Post: 02-20-2012, 10:28 AM
  4. SaveAs Dialogue box
    By saqqer in forum Programming
    Replies: 8
    Last Post: 09-10-2009, 10:49 AM
  5. Replies: 1
    Last Post: 03-18-2009, 12:30 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