format parameter

  • Thread starter Thread starter myxmaster
  • Start date Start date
M

myxmaster

Is it possible to customize the appearance of a parameter query. For
example I have a command button to run the query, the query appears
with the title "Enter Parameter Value" and is a dull gray color. I
would like to customize the title and have the query window appear in
the same color scheme as the rest of the database.
TIA
 
No. The parameter dialog is very limited in scope: one at a time, no
drop-down list, no formatting, ... And they are messy when the user wants to
leave them blank.

Use a form to enter the values instead. Since you are starting with a
command button, that should be quite easy.

For a simple example, see:
Limiting a Report to a Date Range
at:
http://allenbrowne.com/casu-08.html

For a more comprehensive example, see:
Search form - Handle many optional criteria
at:
http://allenbrowne.com/ser-62.html
 
Is it possible to customize the appearance of a parameter query. For
example I have a command button to run the query, the query appears
with the title "Enter Parameter Value" and is a dull gray color. I
would like to customize the title and have the query window appear in
the same color scheme as the rest of the database.
TIA
Click to expand...

Create a form with unbound text controls on it.
You can color and customize it however you wish.
In the query, in place of using [Enter your parameter] as parameter
prompt, use
forms!FormName!ControlName

Use a command button on this form to open the query.
DoCmd.OpenQuery "QueryName"
 
Back
Top