Solved

Access 2010 How do I change the title bar text for a dialog box?

Posted on 2014-04-12
3
603 Views
Last Modified: 2014-04-12
When I run my query there is a title bar at the top of the dialogbox that says "Enter Parameter Value" my end users will not understand this statement. Can I change or remove this title?
0
Comment
Question by:bootsb156
3 Comments
 
LVL 27

Expert Comment

by:MacroShadow
ID: 39996761
You can't change it.
0
 
LVL 47

Accepted Solution

by:
Dale Fye (Access MVP) earned 500 total points
ID: 39996835
But instead of using a parameter query, you could provide them with a form to enter the value prior to running the query.  This is a more professional method as it allows you to test the value in the control on the form prior to executing the query.  It also provides you with the option of presenting the user with a combo box or listbox from which to select the appropriate value.

With a parameter query, that pops up an input box, you have no such ability to test the value that was input, so if the user mistypes a value and gets zero results, they have no way of knowing whether they simply entered a wrong value, or whether there were no results for the entered value.
0
 

Author Closing Comment

by:bootsb156
ID: 39996919
Many thanks. Option 1 will work for me. They don't want me to use a list box for some reason. I know that any text they type could contain typing errors but I don't have a choice. Also, thanks for the fast response.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Experts-Exchange is a great place to come for help with solutions for your database issues, and many problems are resolved within minutes of being posted.  Others take a little more time and effort and often providing a sample database is very helpf…
A theme is a collection of property settings that allow you to define the look of pages and controls, and then apply the look consistently across pages in an application. Themes can be made up of a set of elements: skins, style sheets, images, and o…
What’s inside an Access Desktop Database. Will look at the basic interface, Navigation Pane (Database Container), Tables, Queries, Forms, Report, Macro’s, and VBA code.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

21 Experts available now in Live!

Get 1:1 Help Now