Free Lessons
Courses
Seminars
TechHelp
Fast Tips
Templates
Topic Index
Forum
ABCD
 
Home   Courses   Index   Templates   Seminars   TechHelp   Forums   Help   Contact   Join   Order   Logon  
 
Home > Forums > Developers
Back to Access Developer Forum    Comments List
Formatting Dialog Boxes Upload Images   Link   Email  
Bernard Gill 
Here is an example of my dialog box:
[Enter Status: 2 Cand - 3 Separated - 4 Reinstated - 5] which is all displayed on one line of dialog

is there a way that i can change its format to reflect two separate lines of dialog? to be displayed as below?

                [Enter Status:
2 Cand - 3 Separated - 4 Reinstated - 5 Member]

of course the input would be any one of the options 2-5. any suggestions would be of great help
Scott Axton 
There isn't enough information here to help you.  Please take a screen shot in design mode and post it using the upload images link in your original post.
Bernard Gill 

Bernard Gill 

Adam Schwanz 
So you want the parameter popup to appear on two lines instead? There's not much you can usually do with the built in features like that, but you could make a form and do whatever you want there, make the form popup instead and enter the value there (set the button that runs the query currently to instead open this form and ask for the value, then run the query off that form)
Scott Axton 
I think I see what you are wanting to do.  I suggest you go watch the Relational Combo video.
Also covered more extensively in Beginner 2

In my opinion that would be a better solution for what you are trying to do.  
You really don't want the user the have to type (or remember)  "2 Cand" or "4 Reinstated"

If you are wanting to have the user choose the status then run the query Watch the Value From a Form video.
Richard Rost 
Bernard, in the future, there's no need to post the same thing in multiple Forums. The admins here read everything anyways. You're not reaching different groups of people. Thanks.
Richard Rost 
And to answer your question, no, there is no way that I know of to insert a line break inside a parameter prompt. You'd have to make your own custom dialog form. You might be able to do it with an InputBox in VBA. I've never tried.
Kevin Yip 
InputBox does allow line breaks in the prompt.  The OP can use that to get the user input, then pass it to the query via VBA, such as:

Dim q as QueryDef
Set q = CurrentDB.QueryDefs("MemberTStatusQ")
q.Parameters("Enter Status: 2 Cand - 3 Separated - 4 Reinstated - 5 Member") = InputBox("Enter Status: " & Chr(13) & Chr(10) & "2 Cand - 3 Separated - 4 Reinstated - 5 Member"

Notice how the Paremeter() property above actually references the parameter name used in query design.  That is why you can't have line breaks in it, because the name is actually used in coding.

Then you can run the query with:

Dim r as Recordset
set r = q.OpenRecordset

Richard Rost 
Nice. You just taught me something. I love it. Can't say I'll ever use it, but it's super cool learning something new.
Richard Rost 
Works like a champ. Thanks, RF.

S = InputBox("Line One" & Chr(13) & Chr(10) & "Line Two")
Richard Rost 
This might make a cool Fast Tip video. :)
Kevin Yip 
Thanks, and I look forward to your video. One great thing about your videos is that they often deal with things that can't be found on any textbook or anywhere.  That column color video you just did mentions a feature that can hardly be found in textbooks or on the Internet -- the one about form controls inheriting color formats from tables and queries.
Richard Rost 
Yeah that's how the TechHelp videos started a few years ago... people would ask me weird questions about things that I didn't cover in any of my videos because they just really didn't fit anywhere... and I didn't want to bore people with things that were so crazy and esoteric that they didn't apply to most people, so I started the TechHelp videos... and then the Fast Tips for things that were just short and quick and didn't really need a 30 minute video. Plus they're fun to record. :)

This thread is now CLOSED. If you wish to comment, start a NEW discussion in Access Developer Forum.
 

 
 
 

The following is a paid advertisement
Computer Learning Zone is not responsible for any content shown or offers made by these ads.
 

Learn
 
Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Seminars
More...
Customers
 
Login
My Account
My Courses
Lost Password
Memberships
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Help
 
Customer Support
Web Site Tour
FAQs
TechHelp
Consulting Services
About
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
PCResale.NET
Order
 
Video Tutorials
Handbooks
Memberships
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Contact
 
Contact Info
Support Policy
Mailing Address
Phone Number
Fax Number
Course Survey
Email Richard
[email protected]
Blog RSS Feed    YouTube Channel

LinkedIn
Copyright 2024 by Computer Learning Zone, Amicron, and Richard Rost. All Rights Reserved. Current Time: 3/28/2024 7:29:38 AM. PLT: 1s