Change caption on prompt in a parameter query

scottb
4StarLounger
Posts: 402
Joined: 14 Apr 2010, 15:59

Change caption on prompt in a parameter query

Post by scottb »

Hi everyone,
Is it possible to change the default caption "Enter parameter value" in a query?
Thank you.
-Scott

User avatar
HansV
Administrator
Posts: 78453
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Change caption on prompt in a parameter query

Post by HansV »

No, that is not possible.
As an alternative, create a form with a text box (or combo box) in which the user can enter the value to be used, and replace the parameter in the query design with

[Forms]![FormName]![ControlName]

where FormName is the name of the form and ControlName is the name of the text box or combo box.
You can design the form the way you like, including its caption.
Best wishes,
Hans

scottb
4StarLounger
Posts: 402
Joined: 14 Apr 2010, 15:59

Re: Change caption on prompt in a parameter query

Post by scottb »

Thanks Hans. That's what I thought but wanted to confirm first. Appreciate the help!