Wrox Programmer Forums
|
Access VBA Discuss using VBA for Access programming.
Welcome to the p2p.wrox.com Forums.

You are currently viewing the Access VBA section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 7th, 2007, 07:26 AM
Authorized User
 
Join Date: Mar 2007
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default Msgbox Help

Hello,

This may sound pretty basic but i need some help with the message in the msgbox() command.
I wish to have a long message displayed over 2 or more lines, i have never had to do this and cannot find any examples on how to, could someone please advise.

my code reads as follows
MsgBox "This Product has no stock on Hand, However there is an Stock Available from an Outstanding Container Order. # Do You Wish to Reserve Stock Against This Order?"

# indicates where i would like to start the second line.

Cheers


 
Old June 7th, 2007, 10:00 AM
Friend of Wrox
 
Join Date: Jun 2003
Posts: 126
Thanks: 5
Thanked 0 Times in 0 Posts
Default

Try This:
MsgBox "This Product has no stock on Hand, However there is an Stock Available from an Outstanding Container Order." & _
vbCrLf & "Do You Wish to Reserve Stock Against This Order?"

Make sure you get your quotation marks in too.
(The "vbCrLf" Tells it to go to the next line.)

Regards,
Laura

FYI...My user id has changed. My old id was lbreitenbach

The only thing standing between you and your goal is doubt. Quit doubting yourself and you'll be able to accomplish anything!
 
Old June 8th, 2007, 12:53 AM
Authorized User
 
Join Date: Mar 2007
Posts: 53
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Thx Laura,

All went well

Regards,

Darren







Similar Threads
Thread Thread Starter Forum Replies Last Post
Msgbox rwalker ASP.NET 1.x and 2.0 Application Design 28 March 20th, 2008 01:23 PM
MsgBox prabodh_mishra Pro VB 6 1 December 29th, 2006 11:51 AM
msgbox Ramakrishna.G General .NET 3 September 14th, 2004 02:17 AM
help with Msgbox helmekki Excel VBA 2 June 25th, 2004 08:24 AM
msgbox bph Access VBA 2 February 6th, 2004 03:00 PM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.