Hi everyone,
Is it possible to change the default caption "Enter parameter value" in a query?
Thank you.
-Scott
Change caption on prompt in a parameter query
-
- 4StarLounger
- Posts: 402
- Joined: 14 Apr 2010, 15:59
-
- Administrator
- Posts: 78545
- Joined: 16 Jan 2010, 00:14
- Status: Microsoft MVP
- Location: Wageningen, The Netherlands
Re: Change caption on prompt in a parameter query
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.
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
Hans
-
- 4StarLounger
- Posts: 402
- Joined: 14 Apr 2010, 15:59
Re: Change caption on prompt in a parameter query
Thanks Hans. That's what I thought but wanted to confirm first. Appreciate the help!