473,848 Members | 1,835 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

@ to go down a line in message box prompt

MIG
In Access 97 I used @ to make message boxes to separate the lines,
rather than have the message all in one line.

In Access 2000, all that happens is that "@" appears all over my
message boxes.

Is this feature in one of the libraries that isn't installed by default
in Access 2000, and if so, does anyone know which one?

Nov 13 '05 #1
6 2772
On 28 Oct 2005 06:39:23 -0700, MIG wrote:
In Access 97 I used @ to make message boxes to separate the lines,
rather than have the message all in one line.

In Access 2000, all that happens is that "@" appears all over my
message boxes.

Is this feature in one of the libraries that isn't installed by default
in Access 2000, and if so, does anyone know which one?


That 'feature' is not available from Access since Access 97.
If you want a work-around see what is available at
http://www.trigeminal.com
He had one some time ago, but I don't know if it's still there.

However, you don't really need anything fancy to go down a line in a
message box. Simply use:
MsgBox "This is line 1." & vbNewLine & "This is line 2."
--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
Nov 13 '05 #2
MIG
Ah, OK; thanks. Didn't spot vbNewLine among the possibilities.

Nov 13 '05 #3

"MIG" <go********@dor eenbird.co.uk> wrote
Ah, OK; thanks. Didn't spot vbNewLine among the possibilities.


Chr$(13) & Chr$(10) will work in expressions where vbNewLine will not. My
recollection is that the MsgBox, unlike most text, only needs the Chr$(10)
{line feed character}, not both. You can split the lines with the control
characters, but you can't bold the first paragraph. You can, however, create
your own Form to display messages to the user... it's only a little more
trouble, once you have the Form designed and implemented, to use it instead
of MsgBox.

When Access 2000 first came out, you could get the Access 97 functionality
by using Eval(MsgBox(Som e@text@here)) because Eval used the "Access MsgBox"
and VBA used the "Office MsgBox". But, checking in Access 2002, it appears
that The Boys and Girls in Redmond considered that a "defect" and
"corrected" it -- it doesn't work any more in Access 2002.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #4
Larry Linson wrote:
When Access 2000 first came out, you could get the Access 97 functionality
by using Eval(MsgBox(Som e@text@here)) because Eval used the "Access MsgBox"
and VBA used the "Office MsgBox". But, checking in Access 2002, it appears
that The Boys and Girls in Redmond considered that a "defect" and
"corrected" it -- it doesn't work any more in Access 2002.


Not sure about the "@" formatting as I don't use it but Eval(Msgbox())
is definately usable in 2002 for supporting unicode characters, Cyrillic
text, etc.
Nov 13 '05 #5
"Trevor Best" wrote
Not sure about the "@" formatting as I
don't use it but Eval(Msgbox()) is
definately usable in 2002 for supporting
unicode characters, Cyrillic text, etc.


I tried MsbBox ("First@Second@ Third") in both Access 97 and Access 2002, run
with Eval in 2002. Access 97 displayed a MsgBox with three lines, first line
in boldface. Access 2002 displayed a MsgBox with one line exactly as coded.

Larry Linson
Microsoft Access MVP
Nov 13 '05 #6
Larry Linson wrote:
I tried MsbBox ("First@Second@ Third") in both Access 97 and Access 2002, run
with Eval in 2002. Access 97 displayed a MsgBox with three lines, first line
in boldface. Access 2002 displayed a MsgBox with one line exactly as coded.


In later (>=2000 versions, I think) one can get the old bold line trick
with WizMsgBox:

Public Sub blahblah()
With WizHook
.Key = 51488399
.WizMsgBox "Bold Line @Not So Bold Line@", _
"The Caption", vbYesNo, 0, ""
End With
End Sub

Disclaimer: Wizhook is undocumented and hidden. TTBOMK Wizhook was first
revealed in CDMA by Peter Walker. One can see all the Wizhook members
(and many other hidden objects) by opening the Object Browser, Right
Clicking and choosing Show Hidden Members. Undocumented and hidden
objects are not intended for normal use, and it's a least as probable
and perhaps more so that they will be changed or removed in future
versions of Access, as it is that visible objects will be changed or
removed.
Nov 13 '05 #7

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

4
44064
by: tommy | last post by:
I'm running sqlplus from a DOS command line and inducing an error by purposly giving it the wrong script (hence, it cannot find the script file.) What it is doing is exiting to the SQL> prompt as show below. What I NEED it to do is exit to the DOS prompt. c:\>sqlplus someuser/mypass@mydb NonExistantCommandFile.sql SQL> Does someone know how this can be done or have a commandline switch reference that might have the answer?
6
14604
by: Paul Deverson | last post by:
I'm a newbie to MySQL and am really confused about when I should be using the Command Line Client and when the DOS prompt. I'm using Windows XP and I've just installed MySQL 4.1.10. I can use the Command Line Client to logon as 'root'. It prompts me for a password and then I can create databases, etc. from the mysql prompt. However, if I wanted to logon as a different user, I'm not sure how to do it.
1
1621
by: tim | last post by:
Hello All I am writing an asp app for generating quotes. What I would like to do is allow the user to edit the quote lines without having to open a new page each line. On the quote I have created a loop which goes through the recordset and populates a sort of data grid. Can you use javascript or something so the user can click an edit icon on the appropriate line item in the grid and edit the line details there instead of having to...
10
9304
by: Steve | last post by:
Is there anyone with experience using the Winzip command line add-in? I can't get it to create the zip file with a space in the file name. Using: RetValue = Shell("C:\winzip\wzzip.exe C:\MyFolder\My ZipFile.Zip C:\MyOtherFolder\MyFile.mdb") What is the syntax when you want a space in the zipfile file name?
34
6892
by: Roman Mashak | last post by:
Hello, All! I'm implementing simple CLI (flat model, no tree-style menu etc.). Command line looks like this: <command> <param1> <param2> ... <paramN> (where N=1..4) And idea is pretty simple: 1) get whole string of input line 2) preset table of strings matching <command> 3) preset table of function calls
9
5217
by: Adi | last post by:
Hello eveyone, I wanna ask a very simple question here (as it was quite disturbing me for a long time.) My problem is to read a file line by line. I've tried following implementations but still facing problems: Assume that FILE* filePointer; unsigned char lineBuffer;
9
2503
by: Endless Story | last post by:
My last version of Python was 2.4, running smoothly on XP with path c: \Python24 - no need even to include this path in PATH; everything worked as it's supposed to at the command line. Just installed Python 2.5, after uninstalling 2.4 (and also 2.3 which had lingered). Now if I open a shell in Windows Python is not available! Here are the symptoms: - If I open a shell using "Command line here" with XP Powertools, then enter "python"...
3
4583
by: Tom Baxter | last post by:
I just set up VS 2008 B2 and did a simple command line compile from the VS command prompt. I received this warning: warning CS1668: Invalid search path 'C:\Program Files\Microsoft SDKs\Windows\v6.0A\lib' specified in 'LIB environment variable' -- 'The system cannot find the path specified. ' When I checked, sure enough, the "lib" directory is not present'. Perhaps I
7
9381
by: Jwe | last post by:
Hi, I've written a program which has both a command line interface and Windows form interface, however it isn't quite working correctly. When run from command line with no arguments it should display the Windows form. The form is being displayed but the command only returns when the form is closed. I want the command line to return immediately, leaving the form displayed.
0
9893
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
9738
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10665
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10723
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7894
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
7070
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5735
by: TSSRALBI | last post by:
Hello I'm a network technician in training and I need your help. I am currently learning how to create and manage the different types of VPNs and I have a question about LAN-to-LAN VPNs. The last exercise I practiced was to create a LAN-to-LAN VPN between two Pfsense firewalls, by using IPSEC protocols. I succeeded, with both firewalls in the same network. But I'm wondering if it's possible to do the same thing, with 2 Pfsense firewalls...
2
4139
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3177
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.