Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Parameter Title Replacement (Access 2003)

    This is another one of those non-essential, but wouldn
    Cheers,
    Andy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Parameter Title Replacement (Access 2003)

    The parameter prompt is not customizable, so I usually create a small form with a text box (and other controls as needed). You can set the caption of the form and of the label belonging to the text box to whatever you want, and you can format it any way you want. Instead of [Enter Customer Name]. use [Forms]![NameOfTheForm]![NameOfTheTextBox] in the query.

    Note: this will only work if the form is open, otherwise the user will see an even more incomprehensible paramter prompt asking for the value of [Forms]![NameOfTheForm]![NameOfTheTextBox]. So I open the form or report that uses the parameter query from a command button on the same form.
    Attached Images Attached Images
    • File Type: png x.png (4.9 KB, 0 views)

  3. #3
    5 Star Lounger
    Join Date
    Nov 2001
    Location
    Toronto Canada
    Posts
    920
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Parameter Title Replacement (Access 2003)

    Thanks Hans, I thought as much with respect to the Parameter Title. Bill doesn't like anyone fooling with his choices and probably just as well when there are people like myself loose. I think I've seen the actual sample you displayed, so I'll track it down and try to follow suit.

    Cheers,
    Cheers,
    Andy

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •